Brian,
No data in the system is corrupted, just most of the dump and output routines
in order PostgreSQL versions assume that oid == int (signed int), which is not
true since few releases... or maybe never was true.
Note that if you reference anything by oid, you should change your queries from
I have had similar troubles, related to oid overflow. I had to modify pg_dump
to properly cast queries that contain oids. This is against 7.1.3 source. The
patch was hacked quickly, in order to get a corrupted database reloaded, and
this while I was traveling in another country... so it is far f
Nope- checked the filename. The libs match up. Thanks for your help,
though--I appreciate it. Please see my reply to Tom regarding OID's...
any insight on how to fix that?
thank you all,
brian
On Tue, 2002-12-10 at 00:26, Dan Langille wrote:
> On 10 Dec 2002 at 0:02, Tom Lane wrote:
>
> > Br
Thanks again for your input. I think you're right about the OID's.
Watching the query logs, the pg_dump failed just after:
021210.00:58:25.578 [25527] query: SELECT * FROM pg_language WHERE
lanispl ORDER BY oid
MYDB=> select * from pg_language where lanispl order by oid;
lanname | lanispl | l
On 10 Dec 2002 at 0:02, Tom Lane wrote:
> Brian Fujito <[EMAIL PROTECTED]> writes:
> >> What exactly are you doing to drop and re-add the language? I
> >> should think CREATE LANGUAGE would fail if the handler proc isn't
> >> there.
>
> > I've tried both ways:
>
> > createlang/droplang from the
Brian Fujito <[EMAIL PROTECTED]> writes:
>> What exactly are you doing to drop and re-add the language? I should
>> think CREATE LANGUAGE would fail if the handler proc isn't there.
> I've tried both ways:
> createlang/droplang from the command line as user postgres
> and:
> CREATE FUNCTION pl
Thanks for your input--
I've tried both ways:
createlang/droplang from the command line as user postgres
and:
CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
'/usr/lib/pgsql/plpgsql.so' LANGUAGE 'C';
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
HANDLER plpgsql_call_ha
On 9 Dec 2002 at 21:33, [EMAIL PROTECTED] wrote:
> Does postgresql have a similar facility, or do I have to script some
> solution, perhaps forcing all sessions to be dropped before doing a
> pg_dump ?
>From man pg_dump and http://www.postgresql.org/idocs/index.php?app-
pgdump.html:
pg_dump make
pg_dump does a snapshot at backup start, so your backups will be
consistent even if there is activity.
---
[EMAIL PROTECTED] wrote:
>
>
> Hi:
>
> A question regarding backups. Commercial databases I've administered have
Hi:
A question regarding backups. Commercial databases I've administered have had
some facility to freeze or redirect transactions when a backup is being taken
from a database which is online, in order to insure that the backup snapshots a
consistant database.
Does postgresql have a similar fa
It should have worked, but edit Makefile.shlib and remove that offending
export from the link line. That may fix it.
---
Shibashish wrote:
> Dear Sir,
>
> I use SCO Open Server 5.0.5 on an intel box. Although I have instal
Lamar Owen wrote:
>[...]
> > 2) when postgres is launched the script do:
> > echo " [ OK ] "
> > but should be more correctly:
> > echo_success
>
> Hmmm. I thought that used to work right let me check.
It will work the same (if the format did not change), but I can mod
On Sunday 08 December 2002 11:45, Gaetano Mendola wrote:
> the file pgdb.py distribuited with Postgresql 7.3 RPM ( RedHat 8.0)
> is affectd by an error that not permit anymore to use the
> pgdb interface for python.
Then the official 7.3 tarball is also buggy.
> There is also in the script for la
Brian Fujito <[EMAIL PROTECTED]> writes:
> I'm running postgres-7.0.3 on RH7.1 using RedHat RPMs.
> I recently added plpgsql as a language to one of my databases,
> and now when I try to do a pg_dump, I get:
> "dumpProcLangs(): handler procedure for language plpgsql not found"
> If I drop the la
hi there,
I'm running postgres-7.0.3 on RH7.1 using RedHat RPMs.
I recently added plpgsql as a language to one of my databases,
and now when I try to do a pg_dump, I get:
"dumpProcLangs(): handler procedure for language plpgsql not found"
If I drop the language, pg_dump works fine, but if I ad
Erin Munro <[EMAIL PROTECTED]> writes:
> An empty database cluster takes up 20 MB, 16 of which
> are dedicated to a WAL file. This seems to be a lot
> for a small or low-traffic database. Is there any way
> to reduce the size of this WAL file, besides reverting
> to version 7.0 (where WAL isn't use
On Mon, 9 Dec 2002, Erin Munro wrote:
> An empty database cluster takes up 20 MB, 16 of which
> are dedicated to a WAL file. This seems to be a lot
> for a small or low-traffic database. Is there any way
> to reduce the size of this WAL file, besides reverting
> to version 7.0 (where WAL isn't us
An empty database cluster takes up 20 MB, 16 of which
are dedicated to a WAL file. This seems to be a lot
for a small or low-traffic database. Is there any way
to reduce the size of this WAL file, besides reverting
to version 7.0 (where WAL isn't used)?
Thanks -Erin
---(
Thankyou! That worked, much easier than dumping the db..
thanks
Anders
On Monday, December 9, 2002, at 09:35 AM, Tom Lane wrote:
Anders Bogdan <[EMAIL PROTECTED]> writes:
I've created and deployed a number of databases and am now getting
around to adding some table maintenance (a vacuum script
Anders Bogdan <[EMAIL PROTECTED]> writes:
> I've created and deployed a number of databases and am now getting
> around to adding some table maintenance (a vacuum script). But, the
> script can't run as the "postgres" user. It runs as a defined db user
> "admin".. Unfortunately, in my db schema
Greetings!
Sort of a newbie-ish question, I haven't seen it in the archives so
thought I'd ask.
I've created and deployed a number of databases and am now getting
around to adding some table maintenance (a vacuum script). But, the
script can't run as the "postgres" user. It runs as a defined db
hi geeks,
i am a newbie to DBA and need to know how to create a script to automate
the installation of postgres on linux and create a defined schema on the
server.any directions is greatly appreciated.
thanks
kris
_
MSN 8 helps
Title: RE: [ADMIN] Connection problem (newbie question)
Try these great walkthroughs & tips:
http://www.systinet.com/doc/wasp_uddi/databaseInstallationGuide/InstallingDatabaseServers.html
http://www.ejip.net/faq/postgresql_win_setup_faq.jsp
http://php.weblogs.com/discuss/post_tips
Other gr
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Hello
I would like to know the procedure to install PostGres
on Windows NT
machine. Also, if you could please also send me the
Installation, how to download ?
--- Paul Kavanagh <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've just installed Postgresql 7.3 via Cygwin on
> Win2K, started the
> postma
Hello Paul:
What user are you using. Remember, you have a brand new install and
haven't created any users yet, except for the superuser(postgres). Try
connecting as the postgres(superuser).
btw, are you trying to start postmaster as root? it seems that there's a
bug in postgresql: it says it st
26 matches
Mail list logo
