Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 945F79FB285 for ; Wed, 29 Nov 2006 15:14:49 -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 95299-04 for ; Wed, 29 Nov 2006 15:14:29 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by postgresql.org (Postfix) with ESMTP id E45559FB228 for ; Wed, 29 Nov 2006 15:14:27 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so1684953ugf for ; Wed, 29 Nov 2006 11:14:26 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=UBj6mdVVXCGGZMRVXIifNIrNmfZAq6j+JAmltWN79bR287FOmGlVN3xq5DsK9TBl7SABngsUX06T1ls8tcw+3g5FRE7KBX/amCaLT5bSGDc2BifsKsWbR+jJbweNQ3JIa82GAtNHkqy0EMS0B4FWgiF27fTncemrWW4xxlsvlwA= Received: by 10.67.27.3 with SMTP id e3mr3963458ugj.1164827666043; Wed, 29 Nov 2006 11:14:26 -0800 (PST) Received: by 10.66.245.7 with HTTP; Wed, 29 Nov 2006 11:14:25 -0800 (PST) Message-ID: <2c5b22d10611291114x13b9bb43j51127528afb8ff20@mail.gmail.com> Date: Wed, 29 Nov 2006 20:14:25 +0100 From: "Edoardo Ceccarelli" To: "Richard Broersma Jr" , pgsql-admin@postgresql.org Subject: Re: dump from 8.x restore to 7.3.x In-Reply-To: <475722.43429.qm@web31810.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_55028_23202121.1164827665913" References: <456D992A.90903@axa.it> <475722.43429.qm@web31810.mail.mud.yahoo.com> X-Google-Sender-Auth: a035a30d10b36c28 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/239 X-Sequence-Number: 23766 ------=_Part_55028_23202121.1164827665913 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Thank you for this infos, I wasn't sure about this, now, at least, I know that this is not possible. On the other hand, even the most experienced database programmer / administrator when upgrading a production environment can't be 100% sure about whether the application,will fail or not. Of course, testing is the only way to ensure that everything will be as smooth as possible but a real safety net would be to establish a common dump file format across different PG versions. I will keep searching ... and testing of course :) > > My understanding is that dumps are not backwards compatible. Any dumps > created with a Version 8.* > pg_dump cannot be used for any older versions. If you want "play it safe" > you should create a new > server for the postgresql version 8.1 to preform validation tests with > your front-ends. After you > are satisfied that everything works well you can replace the version 7 > production server with > version 8. > > If you would like a safety net beyond this you could contact one of the > PostgreSQL consulting > companies to walk you through the integration of V.8.1 into your > projection system. > > Regards, > > Richard Broersma Jr. > ------=_Part_55028_23202121.1164827665913 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Thank you for this infos, I wasn't sure about this, now, at least, I know that this is not possible.
On the other hand, even the most experienced database programmer / administrator  when upgrading a production environment can't be 100% sure about whether the application,will fail or not.
Of course, testing is the only way to ensure that everything will be as smooth as possible but a real safety net would be to establish a common dump file format across different PG versions.
I will keep searching ... and testing of course :)



My understanding is that dumps are not backwards compatible.  Any dumps created with a Version 8.*
pg_dump cannot be used for any older versions.  If you want "play it safe" you should create a new
server for the postgresql version 8.1 to preform validation tests with your front-ends.  After you
are satisfied that everything works well you can replace the version 7 production server with
version 8.

If you would like a safety net beyond this you could contact one of the PostgreSQL consulting
companies to walk you through the integration of V.8.1 into your projection system.

Regards,

Richard Broersma Jr.

------=_Part_55028_23202121.1164827665913--