Thread: Re: [BUGS] postgresql downgrade issue
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.zhang@qunar.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
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 HsuHello,
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
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