Re: [BUGS] postgresql downgrade issue

From: 許耀彰 <85131853(at)ss25(dot)mcu(dot)edu(dot)tw>
To: 张文升 <wensheng(dot)zhang(at)qunar(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-admin(at)postgresql(dot)org, jaime(dot)casanova(at)2ndquadrant(dot)com
Subject: Re: [BUGS] postgresql downgrade issue
Date: 2015-11-21 00:55:34
Message-ID: CAF8YJ8F5+GSY5_-M0GtJydwNJeYkXi_2feEX4d3K5mNetE+Dzw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-bugs

Dear Support Team,
Thank you for your kindly assistance. How can we setup postgresql conf
file, because after we downgrade postgresql from 9.4 to 9.3, we can not
connect postgresql database from other computer? Thank you.
Best Regards, Anderson Hsu

2015-11-16 10:37 GMT+08:00 张文升 <wensheng(dot)zhang(at)qunar(dot)com>:

>
> 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 Sridhar N Bamandlapally 2015-11-21 07:24:53 Re: [ADMIN] How to drop stats on table
Previous Message Williams, Alex 2015-11-20 19:50:41 Re: Question on Hot Standby in PostgreSQL

Browse pgsql-bugs by date

  From Date Subject
Next Message David Gould 2015-11-21 01:14:50 Re: Confusing error message with too-large file in pg_basebackup
Previous Message Tom Lane 2015-11-21 00:11:23 Re: Confusing error message with too-large file in pg_basebackup