From: | Daniel Rubio <drubior(at)tinet(dot)org> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | No pg_dumplo on 8.2.4 |
Date: | 2007-09-05 07:31:05 |
Message-ID: | 46DE5B39.3030902@tinet.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-performance |
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
********************************************************
From | Date | Subject | |
---|---|---|---|
Next Message | Khan, Mahmood Ahram | 2007-09-05 11:27:12 | Current Query ? |
Previous Message | Daniel Rubio | 2007-09-05 07:22:55 | Can't login to 8.2.4 if not superuser... |
From | Date | Subject | |
---|---|---|---|
Next Message | Hannes Dorbath | 2007-09-05 08:20:31 | Re: Performance on 8CPU's and 32GB of RAM |
Previous Message | Gregory Stark | 2007-09-04 23:24:32 | Re: Vacum Analyze problem |