Re: pg_dump fail beacuse of oid larger than int32 - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump fail beacuse of oid larger than int32
Date
Msg-id 17813.1042571574@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump fail beacuse of oid larger than int32  ("Ragnar Garli" <ragnar_garli@hotmail.com>)
List pgsql-general
"Ragnar Garli" <ragnar_garli@hotmail.com> writes:
>> Use a more recent pg_dump.  7.3.1's pg_dump should be able to talk to
>> your 7.1.3 server and extract the data without problems.

> Sorry, but pg_dump from 7.3.1 fails too. The problem is the errormessage it
> gets from the backend when pg_dump scans throug the pg_description table
> using the oids for the tables in the database.

> Just look at the d2 debug output from the postmaster:
> DEBUG:  StartTransactionCommand
> DEBUG:  query: SELECT description FROM pg_description WHERE objoid =
> 2325712020

This is not 7.3.1 pg_dump: you can look at the sources for yourself.
Against a 7.1 server it will do

        appendPQExpBuffer(query, "SELECT description FROM pg_description WHERE objoid = '%s'::oid", oid);

I suggest double-checking your PATH.  You must be invoking the wrong
pg_dump.

            regards, tom lane

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Server error and deadlocks
Next
From: Dennis Gearon
Date:
Subject: 'cgi-version' of pgsql