Received: from maia.hub.org (maia-4.hub.org [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 2B4A6632C94 for ; Wed, 5 May 2010 13:39:01 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 90486-06 for ; Wed, 5 May 2010 16:38:54 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id DBD666329F4 for ; Wed, 5 May 2010 13:38:53 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o45GcoU6004230; Wed, 5 May 2010 12:38:50 -0400 (EDT) To: Jason Tan Boon Teck cc: Greg Smith , pgsql-admin@postgresql.org Subject: Re: Downgrading v8.4 database to v8.3 In-reply-to: References: <4BE1958F.8050708@2ndquadrant.com> <3377.1273076004@sss.pgh.pa.us> Comments: In-reply-to Jason Tan Boon Teck message dated "Thu, 06 May 2010 00:27:45 +0800" Date: Wed, 05 May 2010 12:38:50 -0400 Message-ID: <4229.1273077530@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/72 X-Sequence-Number: 34545 Jason Tan Boon Teck writes: > I don't think I have used any new v8.4 feature, since I finally had my > first encounter with v8.4 this week. > What should i be looking for in the dump script? [ shrug... ] You never explained what failed about your previous attempt, so it's hard to give any detailed guidance. The rule of thumb is to fix whatever 8.3 complains about when you try to load the dump. regards, tom lane