On Thursday, March 31, 2011 6:42:35 am Daniele Varrazzo wrote:
>
> To connect to a database on the local machine, the quick answer is:
> add host=127.0.0.1 to the connection string, which makes it connect to
> the network socket instead of the unix socket. And I mean "127.0.0.1",
> not "localhost".
localhost works also:)
No host specified:
[unknown]-2011-03-31 07:00:26.140 PDT-0LOG: connection received: host=[local]
aklaver-2011-03-31 07:00:26.142 PDT-0LOG: connection authorized: user=aklaver
database=test
localhost specified:
[unknown]-2011-03-31 07:00:52.809 PDT-0LOG: connection received: host=127.0.0.1
port=51196
aklaver-2011-03-31 07:00:52.864 PDT-0LOG: connection authorized: user=aklaver
database=test
127.0.0.1 specified:
[unknown]-2011-03-31 07:01:29.853 PDT-0LOG: connection received: host=127.0.0.1
port=51197
aklaver-2011-03-31 07:01:29.922 PDT-0LOG: connection authorized: user=aklaver
database=test
>
> All the gory details are in the pg_hba.conf documentation.
>
> -- Daniele
--
Adrian Klaver
adrian.klaver@gmail.com