Re: Please Help me with connecting my PostgreSQL

On Thursday, March 31, 2011 7:12:22 am David Blewett wrote:
> 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.

Just to be clear I am not the OP:)

--
Adrian Klaver
adrian.klaver@gmail.com