trouble migrating large objects from 7.1.3 to 7.3.2 - Mailing list pgsql-admin

From John M. Layman
Subject trouble migrating large objects from 7.1.3 to 7.3.2
Date
Msg-id 000801c307c8$3950dc00$0400a8c0@frijid.net
Whole thread Raw
List pgsql-admin
Hi - I'm trying to migrate a database with large objects from 7.1.3 to 7.3.2 & have so far been unsuccessful.  I'm running both 7.1.3 & 7.3.2 on the same machine (running Slackware Linux 8.1) and I'm using the following command to migrate the data:
 
pg_dump -p 6543 -b -Ft -v -o dbase | pg_restore -p 5432 -Ft -v -o -d dbase
 
The above command causes pg_restore to fail with the following error:
 
pg_restore: [tar archiver] could not find header for file 37.dat in tar archive
 
If I omit the -o options, the dump & restore seem to work, but the OID's are incorrect & cannot be referenced.  I know the data is there because the size of the new database on disc is roughly the same as the old database, but I cannot reference any of the data in the OID fields (all other fields are okay).  All the values in the new OID fields increase by two, rather than represent the actual size of the data in the field.  I have noticed that if I use psql to view the OID fields while the data is migrating, the numbers look correct right up until the end.  It seems that during the last phase of pg_restore, the OID numbers get reset to some sequence that just increases by two for every OID.  Here's a sample of what is in the OID column of both the old & new databases:
 
  old            new
 
26916        17034
29118        17036
30787        17038
33030        17040
36042        17042
 
The same problem occurs whether I pipe the output from pg_dump to pg_restore or use an intermediate file.  I've also tried using pg_dumplo & get the same results (no error, just OID's whose value increase by two).
 
I've seen messages in the archive from other people with the same problem, but no answers were given.
 
Any ideas?
 
Thanks.
 
 
                                        John Layman
 
 
 
 

pgsql-admin by date:

Previous
From: "Ricardo Sardano Guanciale"
Date:
Subject: no password required
Next
From: "codeWarrior"
Date:
Subject: Re: GRANT on all tables?