| From: | David Blewett <david(at)dawninglight(dot)net> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
| 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:12:22 |
| Message-ID: | AANLkTi=p_ibFrEj35GjDHpFQ3kH1wHT++vfSOk1k6ajv@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | psycopg |
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.
--
Thanks,
David Blewett
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2011-03-31 14:15:40 | Re: Please Help me with connecting my PostgreSQL |
| Previous Message | Adrian Klaver | 2011-03-31 14:07:57 | Re: Please Help me with connecting my PostgreSQL |