Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id E57CE632F48 for ; Wed, 5 May 2010 12:58:21 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 26082-02 for ; Wed, 5 May 2010 15:58:14 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.10]) by mail.postgresql.org (Postfix) with ESMTP id 75C19632735 for ; Wed, 5 May 2010 12:58:14 -0300 (ADT) Received: from [192.168.0.105] (pool-96-244-14-10.bltmmd.fios.verizon.net [96.244.14.10]) by mrelayeu.kundenserver.de (node=mrbap1) with ESMTP (Nemesis) id 0LrIS4-1NDMkP0Kq4-013CFn; Wed, 05 May 2010 17:58:09 +0200 Message-ID: <4BE1958F.8050708@2ndquadrant.com> Date: Wed, 05 May 2010 11:58:07 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Jason Tan Boon Teck CC: pgsql-admin@postgresql.org Subject: Re: Downgrading v8.4 database to v8.3 References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V01U2FsdGVkX1/SRFdvO3JxdASVGYT8t7ISxpKd94ogqrQXTVJ gSP5JVHYy4ZjcZR/tmjUZZ4KQmcryxuAL40G+pkZcCUtyXwEcz nJM5QuuMgVdB7WJsY2A+DYSZaH+wDSn X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.436 tagged_above=-10 required=5 tests=AWL=0.464, BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201005/64 X-Sequence-Number: 34537 Jason Tan Boon Teck wrote: > I need to move some databases written in Psql v8.4 to the stable > production server running v8.3. I tried pg_dump and pg_restore as well > as PgAdmin3. I am unable to do so due to the backward > incompatibility. Is there anyway to do this? > You can try connecting a 8.3 client to the 8.4 server, then running pg_dump from that 8.3 client. That's a common approach for dump/restore when moving forward a version, and it may resolve your issue when moving backward one too. The 8.3 client shouldn't dump anything the 8.3 server doesn't know how to restore. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.us