Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A5D579F9A29 for ; Wed, 5 Sep 2007 04:31:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 04701-04 for ; Wed, 5 Sep 2007 04:31:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.tinet.org (mail.tinet.org [195.77.216.130]) by postgresql.org (Postfix) with ESMTP id 770119F9A23 for ; Wed, 5 Sep 2007 04:31:33 -0300 (ADT) Received: (qmail 25215 invoked from network); 5 Sep 2007 07:31:32 -0000 Received: from serena.tinet.org (HELO [127.0.0.1]) ([194.224.210.4]) (envelope-sender ) by mail.tinet.org (qmail-ldap-1.03) with SMTP for ; 5 Sep 2007 07:31:32 -0000 Message-ID: <46DE5B39.3030902@tinet.org> Date: Wed, 05 Sep 2007 09:31:05 +0200 From: Daniel Rubio User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: No pg_dumplo on 8.2.4 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/26 X-Sequence-Number: 26787 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 ********************************************************