From: | "Kuhn, Dylan K (4520500D)" <Dylan(dot)Kuhn(at)navy(dot)mil> |
---|---|
To: | Gustavo Pérez <gustavo(dot)perez(at)upc(dot)es> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: dump among different versions of postgreSQL |
Date: | 2003-09-18 15:16:20 |
Message-ID: | CCA5D544B9C87043A280D89CB7EFB8CC0CA37F@NAWECHLKEX03VA.nadsuswe.nads.navy.mil |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)perez(at)upc(dot)es]
> Sent: Wednesday, September 17, 2003 1:43
> To: pgsql-admin(at)postgresql(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alumne FIB - GUSTAVO PEREZ QUEROL | 2003-09-18 15:34:04 | Re: dump among different versions of postgreSQL |
Previous Message | Stephan Szabo | 2003-09-18 15:02:26 | Re: Postgresql UPDATE LOCKS unrelated rows. |