From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Michael Hanna <taojones(at)sympatico(dot)ca> |
Cc: | <pgsql-php(at)postgresql(dot)org> |
Subject: | Re: Can't connect to 7.4 DB |
Date: | 2004-02-12 15:30:17 |
Message-ID: | Pine.LNX.4.33.0402120827550.4413-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-php |
OK, here's a little trick you may not be aware of.
pg_connect("dbname=mydb user=stan");
will open a local unix domain socket.
pg_connect("host=127.0.0.1 dbname=mydb user=stan");
will open a local TCP/IP connection on the loopback interface.
In order for this to work, your postgresql.conf must have this line
changed:
#tcpip_socket = false
to
tcpip_socket = true
and your pg_hba.conf needs a line like this:
host all all 127.0.0.1 255.0.0.0 trust
So it's likely the "secure by default" mentality of postgresql that's
biting you here.
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua Drake | 2004-02-12 15:31:27 | Re: Can't connect to 7.4 DB |
Previous Message | scott.marlowe | 2004-02-12 15:09:12 | Re: I want to use postresql for this app, but... |
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua Drake | 2004-02-12 15:31:27 | Re: Can't connect to 7.4 DB |
Previous Message | Michael Hanna | 2004-02-12 13:36:45 | Can't connect to 7.4 DB |