Search Postgresql Archives

Re: pg_hba.conf : bad entry for ADDRESS

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Aug 25, 2016 at 4:29 PM, Francisco Olarte
<folarte@xxxxxxxxxxxxxx> wrote:
> Hi Arnaud:
> On Thu, Aug 25, 2016 at 4:18 PM, arnaud gaboury
> <arnaud.gaboury@xxxxxxxxx> wrote:
>> There is a public IP with a domain name (http works OK).
> Nice to know, but does not matter if all you use is 127.0.0.1
>
>
>> I entered this line in pg_hab.conf:
>
> Have you checked the filename? you are saying HAB, but it is HBA (
> Host Based Auth ) . May be a typo,

Yes it is.

but better safe then sorry. And
> have you checked it is stored in the right place?
>
>
>> ------------------------------
>>  host     mattermost         mmuser      127.0.0.1       md5
>> --------------------------------------------------------
>
> 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:
---------------------------------------------
     75
     76 # TYPE  DATABASE            USER        ADDRESS        METHOD    OPTION
     77
     78 # "local" is for Unix domain socket connections only
     79 local   thetradinghall      mailman                     peer
    map=mailmap
     80 local   all                 postgres                    trust
     81 #-------------------------------------------------------------------#
     82
     83 # IPv4 local connections:
     84 host     mattermost         mmuser      127.0.0.1/24    md5
     85 # IPv6 local connections:
     86
     87
     88 #--------------------------------------------------------------------#
     89

>
>
> Also, did you signal the postmaster to reread after adding the line?

What do you mean?
>
> Francisco Olarte.



-- 

google.com/+arnaudgabourygabx


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux