Re: Starting PostgreSQL

On Saturday 11 October 2008 7:33:20 am admin wrote:
> Sorry folks, a perennial one I'm sure ...
>
> I have read the manual and Googled for a couple of hours but still can't
> connect to PostgreSQL 8.3.4 (the PGDG RPMs running on an up to date
> CentOS 5.2).
>
> I continually get this message:
>
> psql: could not connect to server: No such file or firectory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PDSQL.0"?
>
> Yes, the server is running as 'ps -aux' and 'netstat -l' and 'service
> postgresql status' all confirm.
>
> service postgresql start/stop/restart works without errors
> pg_ctl start/stop/restart works without errors
>
> There is no socket file in /tmp.
> I believe I have PG configured to listen on port 5432 anyway:
>
> listen_addresses = '*'
> port = 5432
>
> Is that enough to make PG listen on a port ... the docs seem to be
> saying that?

What is in the pg_hba.conf file?
Also are you connecting from a remote machine or the local machine?
--
Adrian Klaver
aklaver(at)comcast(dot)net