From: | Joel Burton <jburton(at)scw(dot)org> |
---|---|
To: | Mike Goetz <nospam(at)home(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: running pgaccess on localhost |
Date: | 2001-04-27 14:51:39 |
Message-ID: | Pine.LNX.4.21.0104271050250.17913-100000@olympus.scw.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 27 Apr 2001, Mike Goetz wrote:
> Hello, pgsql newbie here...
>
> I'm trying to run pgaccess on a database I've created, and I get the
> following error:
>
> PostgreSQL error message: Connection to database failed
> PQconnectPoll() -- connect() failed: Connection refused
> Is the postmaster running (with -i) at 'localhost' and accepting
> connections on TCP/IP port '5432'?
>
> Now the postmaster is not normally set up with the -i option, and I'd like
> to keep it that way since I'm intending to use my workstation for local
> development only (are there any security issues by activating the -i
> option?). Indeed turning the -i option on does in fact allow me to use
> pgaccess without error.
>
> However, since I'm running pgaccess from a terminal window on my machine I
> would have thought that this would constitute a local domain socket
> connection (or at least a connection from the localhost), so I'm confused
> by the error message -- am I missing something or do I really have to
> enable TCP/IP connections if I want to initiate database access using
> pgacess from a terminal window?
The fact that you're running pgaccess from a term window doesn't mean that
pgaccess connects to PG w/a local socket.
Someone may know how to configure pgaccess to use a local socket. If not,
use the -i switch, and edit $PGDATA/pg_hba.conf to block access from other
machines. (This is the default setting.)
--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington
From | Date | Subject | |
---|---|---|---|
Next Message | Len Morgan | 2001-04-27 14:52:26 | Re: SQL Where Like - Range it?! |
Previous Message | Joel Burton | 2001-04-27 14:37:41 | Re: SQL Where LIKE - Range it! |