| From: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
|---|---|
| To: | arnaud gaboury <arnaud(dot)gaboury(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_hba.conf : bad entry for ADDRESS |
| Date: | 2016-08-25 15:50:25 |
| Message-ID: | CA+bJJbw3S+M04z14=Fc54awKtmvC8+2-d5pd7Oe-uvUDp8smww@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Arnaud:
On Thu, Aug 25, 2016 at 4:35 PM, arnaud gaboury
<arnaud(dot)gaboury(at)gmail(dot)com> wrote:
>> Are this all the contents of you pg_hba.conf? Note order matters, all
>> non comment ( or at least the host ones ) need to be checked .
> Here is the whole content:
> 79 local thetradinghall mailman peer
> map=mailmap
> 80 local all postgres trust
> 84 host mattermost mmuser 127.0.0.1/24 md5
.. This looks good once you've added the netmask, ehich slipped to me.
>> Also, did you signal the postmaster to reread after adding the line?
> What do you mean?
When you change the file you need to signal the postgres main process
( postmaster ) to reread it by sending it a HUP signal, or using
pg_ctl reload ( your OS/distro may have other methods ).
Francisco Olarte.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ilya Kazakevich | 2016-08-25 15:57:04 | Re: Understanding Postgres Memory Usage |
| Previous Message | arnaud gaboury | 2016-08-25 15:47:45 | Re: pg_hba.conf : bad entry for ADDRESS |