Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] postgresql downgrade issue - Mailing list pgsql-admin

From Glauco Torres
Subject Re: [BUGS] postgresql downgrade issue
Date
Msg-id CAMd+QORFPtY0UZSAhZrjrf8M9Sbf17eYmrNOE2==4EAPiHyZzg@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] postgresql downgrade issue  (Glauco Torres <torres.glauco@gmail.com>)
List pgsql-admin
Tree view





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 by date:

Previous
From: Glauco Torres
Date:
Subject: Re: [BUGS] postgresql downgrade issue
Next
From: Yogi Barot
Date:
Subject: Postgresql 9.4 pg_upgrade issues