No pg_dumplo on 8.2.4

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
********************************************************

Responses

Browse pgsql-admin by date

  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...

Browse pgsql-performance by date

  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