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