I've successfully dumped and restored a database containing large objects with 7.3.3 and previous versions. I've used the 'tar' archive format something like this:
% pg_dump -F t -b dbwithlos | gzip > dump.tar.gz % zcat dump.tar.gz | pg_restore -d restoredbwithlos Dylan Kuhn > -----Original Message----- > From: Gustavo Pérez [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 17, 2003 1:43 > To: [EMAIL PROTECTED] > Subject: [ADMIN] dump among different versions of postgreSQL > > > > I've playing for a while with differents versions of postgreSQL (to > be exact, versions 7.2.2, 7.3.3 and 7.3.4) and I noticed > that the only > one that dumped/restored correctly a database with blob's was > version 7.3.4. > > I made a dump by the book, without OID's. The restoration procedure > worked totally fine with version 7.3.4 ( including the > recalculation of > OID's ). I tryed dumping with version 7.3.3 and restoring the > dump with > version 7.3.4 (which worked fine for me) so I think the problem is > pg_restore. > > May anyone report succesfull restoration with previous versions of > 'pg_restore' ? I think someone pointed that pg_restore was a little > buggy in previous versions, Am I right ? > > Gustavo Pérez > > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index > scan if your > joining column's datatypes do not match > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
