From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | David Blewett <david(at)dawninglight(dot)net> |
Cc: | Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>, psycopg(at)postgresql(dot)org, Lasntonpeng <lanstonpeng(at)gmail(dot)com>, psycopg-owner(at)postgresql(dot)org |
Subject: | Re: Please Help me with connecting my PostgreSQL |
Date: | 2011-03-31 14:15:40 |
Message-ID: | 201103310715.41025.adrian.klaver@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | psycopg |
On Thursday, March 31, 2011 7:12:22 am David Blewett wrote:
> On Thu, Mar 31, 2011 at 10:07 AM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)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(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Daniele Varrazzo | 2011-03-31 14:56:14 | Re: Please Help me with connecting my PostgreSQL |
Previous Message | David Blewett | 2011-03-31 14:12:22 | Re: Please Help me with connecting my PostgreSQL |