Re: running pgaccess on localhost

On Fri, Apr 27, 2001 at 08:24:53AM +0000, 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?

Try not specifying a hostname or port in the login window.  Then it
should use the local unix socket method (I think).

--
Eric G. Miller <egm2@jps.net>