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+QOTNRBS2qESRCDq1HJiwvBtnEMKysSWKLSy_gVJfGO7CMg@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] postgresql downgrade issue  (許耀彰 <85131853@ss25.mcu.edu.tw>)
Responses 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

Regards,
Glauco Torres

pgsql-admin by date:

Previous
From: Yaser Raja
Date:
Subject: Re: Question on Hot Standby in PostgreSQL
Next
From: Glauco Torres
Date:
Subject: Re: [BUGS] postgresql downgrade issue