Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Zx4M2-0007hJ-IX for pgsql-bugs@arkaria.postgresql.org; Fri, 13 Nov 2015 02:44:46 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1Zx4M1-0006tJ-UU for pgsql-bugs@arkaria.postgresql.org; Fri, 13 Nov 2015 02:44:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1Zx4M1-0006sv-7D for pgsql-bugs@postgresql.org; Fri, 13 Nov 2015 02:44:45 +0000 Received: from [59.151.11.101] (helo=Exchange02.qunarservers.com) by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Zx4Lw-0001Xt-IN for pgsql-bugs@postgresql.org; Fri, 13 Nov 2015 02:44:43 +0000 Received: from Exchange10.qunarservers.com (119.254.26.7) by EXCHANGE02.qunarservers.com (59.151.11.104) with Microsoft SMTP Server (TLS) id 14.3.123.3; Fri, 13 Nov 2015 10:44:08 +0800 Received: from [10.89.129.101] (10.89.129.101) by Exchange10.qunarservers.com (192.168.39.94) with Microsoft SMTP Server (TLS) id 14.3.123.3; Fri, 13 Nov 2015 10:44:08 +0800 Message-ID: <56454E77.5080500@qunar.com> Date: Fri, 13 Nov 2015 10:44:07 +0800 From: =?UTF-8?B?5byg5paH5Y2H?= User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Icedove/31.7.0 MIME-Version: 1.0 To: Subject: Re: postgresql downgrade issue References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------070308070107020500010200" X-Originating-IP: [10.89.129.101] X-Host-Lookup-Failed: Reverse DNS lookup failed for 59.151.11.101 (deferred) X-Pg-Spam-Score: 1.1 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org --------------070308070107020500010200 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 8bit hi~~耀彰 you can first dump data from pg9.4 use pg_dump and then restore data to pg9.3 use pg_restore. I hope this can help you. On 2015年11月12日 20:11, 許耀彰 wrote: > Dear Support Team, > If we use ubuntu server to install postgresql9.4, how can we keep > original data to downgrade postgresql from 9.4 to 9.3. Would it be > possible to support the guidance for us ? Thank you. > Best Regards, Anderson Hsu > > 安全提示：本邮件非QUNAR内部邮件，请注意保护个人及公司信息安全，如有索 > 取帐号密码等可疑情况请向secteam发送邮件 > -- ---------------------- 张文升 --------------070308070107020500010200 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: 8bit hi~~耀彰

you can first dump data from pg9.4 use pg_dump and then restore data to pg9.3 use pg_restore.
I hope this can help you.

On 2015年11月12日 20:11, 許耀彰 wrote:

Dear Support Team,
If we use ubuntu server to install postgresql9.4, how can we keep original data to downgrade postgresql from 9.4 to 9.3. Would it be possible to support the guidance for us ? Thank you.

Best Regards, Anderson Hsu

安全提示：本邮件非QUNAR内部邮件，请注意保护个人及公司信息安全，如有索取帐号密码等可疑情况请向 secteam发送邮件

-- 
----------------------
张文升

--------------070308070107020500010200--