Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 1A29C9FA2FC for ; Tue, 5 Dec 2006 01:48:49 -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 02944-01-4 for ; Tue, 5 Dec 2006 01:48:39 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id D8E419FA5C8 for ; Tue, 5 Dec 2006 01:27:22 -0400 (AST) Received: from [10.26.67.79] (72-254-61-58.client.stsn.net [72.254.61.58]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) by noel.decibel.org (Postfix) with ESMTP id 1DEA156437; Tue, 5 Dec 2006 05:27:18 +0000 (UTC) In-Reply-To: <200611301452.37666.peter_e@gmx.net> References: <475722.43429.qm@web31810.mail.mud.yahoo.com> <456EBBEE.7090107@007Marketing.com> <200611301452.37666.peter_e@gmx.net> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: pgsql-admin@postgresql.org, Shane Ambler , Richard Broersma Jr , eddy@axa.it Content-Transfer-Encoding: 7bit From: Jim Nasby Subject: Re: dump from 8.x restore to 7.3.x Date: Mon, 4 Dec 2006 14:25:06 -0800 To: Peter Eisentraut X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.313 tagged_above=0 required=5 tests=AWL, BAYES_20, DATE_IN_PAST_06_12, SPF_PASS X-Spam-Level: X-Archive-Number: 200612/32 X-Sequence-Number: 23824 On Nov 30, 2006, at 5:52 AM, Peter Eisentraut wrote: > 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: 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. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)