Re: error connecting to database - Mailing list pgsql-general

From sklassen@commandprompt.com
Subject Re: error connecting to database
Date
Msg-id 20041001114954.A13387@commandprompt.com
Whole thread Raw
In response to error connecting to database  (Alexander Cohen <alex@toomuchspace.com>)
List pgsql-general
* Alexander Cohen <alex@toomuchspace.com> [2004-10-01 14:42:07 -0400]:

> Im trying to connect locally to a database on a running postgres
> cluster. If i connect with psql, everything is fine and i can transact.
> I i try and connect in my own app, i get this error:
>
> Could not connect to server: permission denied.
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"
>
> I know for a fact postgres is running, i can see with <ps> and also
> <top> in the terminal on Mac OSX 10.3.5.

Try 'netstat -ntpl' intead to see if it's listening.

> What exctly does this error message mean? What permissions is this
> error talking about?

That typically means that you're connecting via the local unix socket
instead of the tcp port. If your application is trying to do the
latter you'll want to uncomment the tcp_socket setting in
postgresql.conf and restart.

--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564

pgsql-general by date:

Previous
From: Alexander Cohen
Date:
Subject: error connecting to database
Next
From: Greg Stark
Date:
Subject: Re: Random not so random