Re: [BUGS] postgresql downgrade issue

From: 张文升 <wensheng(dot)zhang(at)qunar(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: <pgsql-admin(at)postgresql(dot)org>, <85131853(at)ss25(dot)mcu(dot)edu(dot)tw>, <jaime(dot)casanova(at)2ndquadrant(dot)com>
Subject: Re: [BUGS] postgresql downgrade issue
Date: 2015-11-16 02:37:09
Message-ID: 56494155.8020308@qunar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-bugs


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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message clingareddy 2015-11-16 08:17:52 how to take export of one year data from large database which contain 4 years of data.
Previous Message Jaime Casanova 2015-11-13 19:53:51 Re: postgresql downgrade issue

Browse pgsql-bugs by date

  From Date Subject
Next Message Haribabu Kommi 2015-11-16 02:41:31 Re: BUG #13741: vacuumdb does not accept valid password
Previous Message Joshua Yanovski 2015-11-15 19:57:43 Re: BUG #13776: Views with nested composite attributes can break pg_dump