Re: Socket & TCP connections - Mailing list pgsql-admin

From Robert Gravsjö
Subject Re: Socket & TCP connections
Date
Msg-id 4BB04AF1.1030001@blogg.se
Whole thread Raw
In response to Re: Socket & TCP connections  (Nilesh Govindarajan <lists@itech7.com>)
List pgsql-admin

Nilesh Govindarajan skrev 2010-03-29 04.04:
> Hi, it seems to be working now. Can somebody explain to me how ? See
> this pg_hba.conf -

Did you reload the config, i.e pg_ctl reload, after making changes the
first time?

Regards,
roppert

>
> # "local" is for Unix domain socket connections only
> local all root trust
> local all all md5
> # IPv4 local connections:
> #host all root 127.0.0.1/32 trust
> #host all root ::1/128 trust
> host all all 127.0.0.1/32 md5
> host all all ::1/128 md5
>
> Its the same code I think which I wrote previously. But now it asks
> password when connected through TCP and doesn't when connected directly
> as psql -d postgres
>
> PLZ EXPLAIN !! I'm in a big confusion :?
>

pgsql-admin by date:

Previous
From: Greg Smith
Date:
Subject: Re: [PERFORM] Database size growing over time and leads to performance impact
Next
From: Greg Smith
Date:
Subject: Re: Migrate postgres to newer hardware