Thread: pg_dumpall with oids/blobs

pg_dumpall with oids/blobs

From
"Marcin Gil"
Date:
Hi!

I'd like to upgrade my all postgres databases from pg 7.4
to pg 8.0. Many of them use large objects with oids stored
in tables. How can I dump them all at once and restore
with right oids?

Regards,
-Marcin Gil


Re: pg_dumpall with oids/blobs

From
Kretschmer Andreas
Date:
am  Mon, dem 20.12.2004, um 16:16:56 +0100 mailte Marcin Gil folgendes:
> Hi!
>
> I'd like to upgrade my all postgres databases from pg 7.4
> to pg 8.0. Many of them use large objects with oids stored
> in tables. How can I dump them all at once and restore

Read 'man pg_dump' and search for oid.


Regards, Andreas
--
Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau-
fenden Pinguins aus artgerechter Freilandhaltung.   Er ist garantiert frei
von Micro$oft'schen Viren. (#97922 http://counter.li.org)     GPG 7F4584DA
Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)

Re: pg_dumpall with oids/blobs

From
"Marcin Gil"
Date:
----Original Message----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of
Kretschmer Andreas
Sent: Monday, December 20, 2004 4:51 PM
To: 'PGSQL-Novice'
Subject: Re: [NOVICE] pg_dumpall with oids/blobs

> Read 'man pg_dump' and search for oid.
>
Yes, I know about that option. However I need pg_dumpall
not only to dump with oid order but also dump my large objects. AFAIK
pg_dumpall
makes only text (sql) dumps and cannot do binary dumps that are necessary
for blobs. Thus my question (maybe little innacurate) "how can I do it?".

TIA,
-Marcin