Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Zy9ha-0004mw-9Y for pgsql-admin@arkaria.postgresql.org; Mon, 16 Nov 2015 02:39:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1Zy9hZ-0006cy-MG for pgsql-admin@arkaria.postgresql.org; Mon, 16 Nov 2015 02:39:29 +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 1Zy9fv-0004kX-Jv for pgsql-admin@postgresql.org; Mon, 16 Nov 2015 02:37:47 +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 1Zy9fp-0005Lw-MM for pgsql-admin@postgresql.org; Mon, 16 Nov 2015 02:37:46 +0000 Received: from Exchange10.qunarservers.com (192.168.38.247) by EXCHANGE02.qunarservers.com (192.168.23.12) with Microsoft SMTP Server (TLS) id 14.3.123.3; Mon, 16 Nov 2015 10:37:10 +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; Mon, 16 Nov 2015 10:37:10 +0800 Message-ID: <56494155.8020308@qunar.com> Date: Mon, 16 Nov 2015 10:37:09 +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: Bruce Momjian CC: , <85131853@ss25.mcu.edu.tw>, Subject: Re: [BUGS] postgresql downgrade issue References: <56454E77.5080500@qunar.com> <20151113193005.GA27916@momjian.us> In-Reply-To: <20151113193005.GA27916@momjian.us> Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 8bit X-Originating-IP: [10.89.129.101] X-Host-Lookup-Failed: Reverse DNS lookup failed for 59.151.11.101 (failed) X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Thank bruce and Jaime Casanova. I have moved mail to pgsql-admin. On 2015年11月14日 03:30, Bruce Momjian wrote: > On Fri, Nov 13, 2015 at 10:44:07AM +0800, 张文升 wrote: >> 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. > The original poster was not CC'ed on the reply, so I have added him/her. > > --------------------------------------------------------------------------- > > >> >> >> 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发送邮件 >> >> >> -- >> ---------------------- >> 张文升 >> -- ---------------------- 张文升 | PostgreSQL DBA ---------------------- pg开发指南 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=58058230 pg发布流程 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=56215301 pg值班列表 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=50508626 pg机器列表 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=36438672 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin