Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4A9E09FA380 for ; Tue, 5 Dec 2006 08:33:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 32465-04 for ; Tue, 5 Dec 2006 08:33:20 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.187]) by postgresql.org (Postfix) with ESMTP id 383719FA19C for ; Tue, 5 Dec 2006 08:33:19 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so206242nfb for ; Tue, 05 Dec 2006 04:33:18 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=rXLddgmGFhKxxgVX/0ZXe6DLxw+2O8Dg610hvAMD7xutt8VRWUDrmRjkmmzxITc4Bl+DiTBrYympbCPrfYq47KGVZ6B7U8QsnXnbTGuwMf4TwMwdrPdtZJMFDmPEovrsDBR+slv4Bqew6TxvFfIphchCOtdBjbMRMrgiIPoN3q4= Received: by 10.49.55.13 with SMTP id h13mr747490nfk.1165321998335; Tue, 05 Dec 2006 04:33:18 -0800 (PST) Received: from ?192.168.0.71? ( [151.48.232.172]) by mx.google.com with ESMTP id r34sm2429128nfc.2006.12.05.04.33.16; Tue, 05 Dec 2006 04:33:17 -0800 (PST) Message-ID: <4575670E.9050509@axa.it> Date: Tue, 05 Dec 2006 13:33:18 +0100 From: Edoardo Ceccarelli Reply-To: eddy@axa.it User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 To: Jim Nasby CC: Peter Eisentraut , pgsql-admin@postgresql.org, Shane Ambler , Richard Broersma Jr , adamr@informatyka.gdansk.pl Subject: Re: dump from 8.x restore to 7.3.x References: <475722.43429.qm@web31810.mail.mud.yahoo.com> <456EBBEE.7090107@007Marketing.com> <200611301452.37666.peter_e@gmx.net> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/34 X-Sequence-Number: 23826 > > On the other hand, dumping a newer version database with an older > version of *pg_dump* is much more likely to succeed. It's not a > guarantee, but it should get you pretty close. And as someone else > mentioned, doing a plain text dump is probably your best bet in this case. No, that's not an option, I have tried several combinations like using old pg_dump on a new db but the results are always the same: no way to restore a newer db on an older pg (my test were only about PG8 - PG7) The best solution is the one that Adam was suggesting (btw Thank you) in this same thread, doing a "pg_dump -Fp" on the new db and restoring it with a \i FILENAME from the old PG The only issue about this is that it doesn't treat LO's at all, but it was enough in my "disaster recovery" scenario. I started investigating about dumping and restoring LO's and I found a pretty interesting project under the 7.4 contrib dir, but it seems it's not maintained any more and I didn't manage to compile it. Using the lo_export - import function seems doesn't work for "ALL" the LO's of the database.. maybe it's possible to write a query to do that but - again - it wasn't so important to save blobs Thank you again to everybody for your help Edoardo