From: Daniel Rubio <drubior@tinet.org>
To: pgsql-admin@postgresql.org
Subject: No pg_dumplo on 8.2.4
Date: Wed, 05 Sep 2007 09:31:05 +0200
Message-ID: <46DE5B39.3030902@tinet.org> (raw)
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
********************************************************
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: drubior@tinet.org, pgsql-admin@postgresql.org
Subject: Re: No pg_dumplo on 8.2.4
In-Reply-To: <46DE5B39.3030902@tinet.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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