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 <torres.glauco@gmail.com>)
Список pgsql-admin





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
 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Glauco Torres
Дата:
Сообщение: Re: [BUGS] postgresql downgrade issue
Следующее
От: Yogi Barot
Дата:
Сообщение: Postgresql 9.4 pg_upgrade issues