Re: [BUGS] postgresql downgrade issue
От
Glauco Torres
Тема
Re: [BUGS] postgresql downgrade issue
Дата
Msg-id
CAMd+QORFPtY0UZSAhZrjrf8M9Sbf17eYmrNOE2==4EAPiHyZzg@mail.gmail.com
Ответ на
Re: [BUGS] postgresql downgrade issue (Glauco Torres)
Список
Дерево обсуждения
Re: [BUGS] postgresql downgrade issue 张文升 <wensheng.zhang@qunar.com>
Re: [BUGS] postgresql downgrade issue 許耀彰 <85131853@ss25.mcu.edu.tw>
Re: [BUGS] postgresql downgrade issue Glauco Torres <torres.glauco@gmail.com>
Re: [BUGS] postgresql downgrade issue Glauco Torres <torres.glauco@gmail.com>
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
В списке pgsql-admin по дате отправления
