Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 61CF39FA0CC for ; Thu, 30 Nov 2006 07:09:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 13048-01 for ; Thu, 30 Nov 2006 07:09:40 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from ipmail02.adl2.internode.on.net (ipmail02.adl2.internode.on.net [203.16.214.141]) by postgresql.org (Postfix) with ESMTP id E9F229F931E for ; Thu, 30 Nov 2006 07:09:39 -0400 (AST) Received: from ppp247-71.static.internode.on.net (HELO [192.168.8.200]) ([203.122.247.71]) by ipmail02.adl2.internode.on.net with ESMTP; 30 Nov 2006 21:39:35 +1030 X-IronPort-AV: i="4.09,478,1157293800"; d="scan'208"; a="53629287:sNHT27804973" Message-ID: <456EBBEE.7090107@007Marketing.com> Date: Thu, 30 Nov 2006 21:39:34 +1030 From: Shane Ambler User-Agent: Thunderbird 1.5.0.7 (Macintosh/20060909) MIME-Version: 1.0 To: Richard Broersma Jr CC: eddy@axa.it, pgsql-admin@postgresql.org Subject: Re: dump from 8.x restore to 7.3.x References: <475722.43429.qm@web31810.mail.mud.yahoo.com> In-Reply-To: <475722.43429.qm@web31810.mail.mud.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.44 tagged_above=0 required=5 tests=AWL, BAYES_05, BIZ_TLD, SPF_HELO_PASS X-Spam-Level: X-Archive-Number: 200611/248 X-Sequence-Number: 23775 Richard Broersma Jr wrote: > 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. > I don't see that as being the case - there will be exceptions where you have new features in an 8.x database that won't work in a 7.x db but otherwise it shouldn't matter, the dumps can be used to import into other databases than postgres as long as you use dump with inserts instead of copy and use common datatypes. I would expect that if you dump from 7.x into 8.x and have issues then a dump from 8.x into 7.x would work as long as you haven't changed your schema to add 8.x only features. If you have any concerns and want a fall back safety net, then you will want to either not add any 8.x features or document the changes so that the structure can be changed back to be 7.x compatible. Of course not making any schema changes until you are happy to stay with 8.x will help and you could just dump data only to go back. -- Shane Ambler pgSQL@007Marketing.com Get Sheeky @ http://Sheeky.Biz