pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedNo pg_dumplo on 8.2.4
2+ messages / 2 participants
[nested] [flat]
* No pg_dumplo on 8.2.4
@ 2007-09-05 07:31 Daniel Rubio <drubior@tinet.org>
0 siblings, 1 reply; 2+ messages in thread
From: Daniel Rubio @ 2007-09-05 07:31 UTC (permalink / raw)
To: pgsql-admin@postgresql.org
Hi again, a different question ...
On a previous upgrade to 7.4 (I think) I used the pg_dumplo contrib
utility to add the large objects to my restored via pg_dumpall databases
(not all using large objects).
I liked it because it was easy and I hadn't to remove the databases with
large objects to reimport them with the dumped via pg_dump versions
which seemed more work (and more possibilities of problems).
Now I see that theres is not pg_dumplo on contrib directory for 8.2.4
(or at least i did'nt found it)...
Which is the best method to import my large objects in this case?
1.- Import all the stuff via pg_dumpall+psql, drop databases with LO,
import LO databases with pg_dump+psql
2.-Import all the stuff via pg_dumpall+psql, import LO databases with
pg_dump+psql (without delete them)
3.- ??
Thanks in advance
--
********************************************************
Daniel Rubio Rodríguez
OASI (Organisme Autònom Per la Societat de la Informació)
c/ Assalt, 12
43003 - Tarragona
Tef.: 977.244.007 - Fax: 977.224.517
e-mail: drubio a oasi.org
********************************************************
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: No pg_dumplo on 8.2.4
@ 2007-09-05 15:03 Tom Lane <tgl@sss.pgh.pa.us>
parent: Daniel Rubio <drubior@tinet.org>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2007-09-05 15:03 UTC (permalink / raw)
To: Daniel Rubio <drubior@tinet.org>; +Cc: pgsql-admin@postgresql.org
Daniel Rubio <drubior@tinet.org> writes:
> Now I see that theres is not pg_dumplo on contrib directory for 8.2.4
That's because it's obsolete --- regular pg_dump can handle large
objects now.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-09-05 15:03 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-09-05 07:31 No pg_dumplo on 8.2.4 Daniel Rubio <drubior@tinet.org>
2007-09-05 15:03 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox