Re: postgresql downgrade issue

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

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发送邮件
>

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

On 12 November 2015 at 21:44, 张文升 <wensheng(dot)zhang(at)qunar(dot)com> wrote:
>> 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
>
> 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.
>
>

Actually, he should use plain text format (pg_dump default) because
PostgreSQL doesn't support downgrade.
Btw, this is not a bug. Another mailing list should have been more
appropiate, for example: pgsql-general(at)postgresql(dot)org

--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación

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发送邮件
>
>
> --
> ----------------------
> 张文升
>

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription +

On 12 November 2015 at 21:59, Jaime Casanova
<jaime(dot)casanova(at)2ndquadrant(dot)com> wrote:
> On 12 November 2015 at 21:44, 张文升 <wensheng(dot)zhang(at)qunar(dot)com> wrote:
>>> 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
>>
>> 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.
>>
>>

Actually, he should use plain text format (pg_dump default) because
PostgreSQL doesn't support downgrade.
Btw, this is not a bug. Another mailing list should have been more
appropiate, for example: pgsql-general(at)postgresql(dot)org

--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación

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

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
>
>

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
>
>
> Hello,

Check your pg_hba.conf, this probably only released to the localhost (
127.0.0.1/32).

If you want all your network can access your database add this line to your
pg_hba.conf

host all all md5 0/0 (md5, trust and password, this is who you choose)

Once add, you need to reload the postgresql service.

[1] http://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html

Regards,
Glauco Torres

>
>
> 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
>>
>>
>> Hello,
>
> Check your pg_hba.conf, this probably only released to the localhost (
> 127.0.0.1/32).
>
> If you want all your network can access your database add this line to
> your pg_hba.conf
>
> host all all md5 0/0 (md5, trust and password, this is who you
> choose)
>
> Once add, you need to reload the postgresql service.
>
> [1] http://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html
>
>
I forgot listen_addresses the postgresql.conf parameter. If you want to
release for all connect it should be uncommented.

Like this example:
listen_addresses = '*'

If so you will need to Reboot the postgresql service

[1] http://www.postgresql.org/docs/9.4/static/runtime-config-connection.html

Regards,
Glauco Torres