Re: dump among different versions of postgreSQL - Mailing list pgsql-admin

From Kuhn, Dylan K (4520500D)
Subject Re: dump among different versions of postgreSQL
Date
Msg-id CCA5D544B9C87043A280D89CB7EFB8CC0CA37F@NAWECHLKEX03VA.nadsuswe.nads.navy.mil
Whole thread Raw
In response to dump among different versions of postgreSQL  (Gustavo Pérez <gustavo.perez@upc.es>)
List pgsql-admin
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
>

pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Postgresql UPDATE LOCKS unrelated rows.
Next
From: Tom Lane
Date:
Subject: Re: [PERFORM] How to force an Index ?