Re: [BUGS] postgresql downgrade issue

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

In response to

Browse pgsql-admin by date

  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

Browse pgsql-bugs by date

  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