From: | Glauco Torres <torres(dot)glauco(at)gmail(dot)com> |
---|---|
To: | 許耀彰 <85131853(at)ss25(dot)mcu(dot)edu(dot)tw> |
Cc: | 张文升 <wensheng(dot)zhang(at)qunar(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: [BUGS] postgresql downgrade issue |
Date: | 2015-11-24 12:54:21 |
Message-ID: | CAMd+QORFPtY0UZSAhZrjrf8M9Sbf17eYmrNOE2==4EAPiHyZzg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-bugs |
>
>
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Yogi Barot | 2015-11-24 15:13:01 | Postgresql 9.4 pg_upgrade issues |
Previous Message | Glauco Torres | 2015-11-24 12:30:41 | Re: [BUGS] postgresql downgrade issue |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2015-11-24 14:22:58 | Re: Confusing error message with too-large file in pg_basebackup |
Previous Message | Glauco Torres | 2015-11-24 12:30:41 | Re: [BUGS] postgresql downgrade issue |