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:gustavo.perez@upc.es]
> Sent: Wednesday, September 17, 2003 1:43
> To: pgsql-admin@postgresql.org
> 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
>