On Thu, Mar 31, 2011 at 10:07 AM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
> 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
The host=[local] bit means it accepted the connection over the UNIX
socket. This won't work if you are trying to connect remotely.
--
Thanks,
David Blewett