Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 81DBA9FA0CC for ; Thu, 30 Nov 2006 09:52:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 93815-03 for ; Thu, 30 Nov 2006 09:52:36 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 69E359F9C9E for ; Thu, 30 Nov 2006 09:52:41 -0400 (AST) Received: (qmail invoked by alias); 30 Nov 2006 13:52:39 -0000 Received: from dslb-084-063-008-090.pools.arcor-ip.net (EHLO colt.pezone.net) [84.63.8.90] by mail.gmx.net (mp020) with SMTP; 30 Nov 2006 14:52:39 +0100 X-Authenticated: #495269 From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: dump from 8.x restore to 7.3.x Date: Thu, 30 Nov 2006 14:52:35 +0100 User-Agent: KMail/1.9.5 Cc: Shane Ambler , Richard Broersma Jr , eddy@axa.it References: <475722.43429.qm@web31810.mail.mud.yahoo.com> <456EBBEE.7090107@007Marketing.com> In-Reply-To: <456EBBEE.7090107@007Marketing.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200611301452.37666.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/250 X-Sequence-Number: 23777 Shane Ambler wrote: > 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. Restoring dumps from new versions into old versions doesn't work (without a lot of manual work). Example cases: 8.2 dump won't install into 8.1 because it sets standard_conforming_stings, which can't be set in 8.1 8.1 dump won't install into 8.0 because it dumps users as roles, but roles don't exist in 8.0. 8.0 dump won't install into 7.4 because it dumps tablespaces, which don't exist in 7.4. etc. etc. Obviously you can see that getting pretty bad if you want to go from 8.1 all the way to 7.3. -- Peter Eisentraut http://developer.postgresql.org/~petere/