Starting PostgreSQL

On Sun, 2008-10-12 at 00:03 +0930, admin wrote:

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"?

Socket file name is wrong -- and the port...
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org

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@comcast.net

admin <mick@mjhall.org> writes:

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"?

If it's really saying .0, and not .5432, then the problem is on the
client side --- it's got the wrong idea about the port number to
connect to. Perhaps you have PGPORT set to something bogus in the
client environment?

regards, tom lane

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.

Do you mean you have something like this in your netstan -l?
unix 2 [ ACC ] STREAM LISTENING 12587 /tmp/.s.PGSQL.5432

note, this is on a linux box with postgresql in standard configuration.
Just look at the port number embedded in the socket name. I don't really
think you can run a process on port 0. I think your psql is looking for
the wrong socket.

Try:
$ psql -p 5432 ...

If you don't see any unix socket for PG (I don't even think that's possible),
then you need to use IP sockets:

$ psql -p 5432 -h localhost ...

service postgresql start/stop/restart works without errors
pg_ctl start/stop/restart works without errors

There is no socket file in /tmp.

Opps sorry I missed this. Well double check with netstat, but it's
possible your PG is not configured for Unix sockets... even if I
wouldn't know how to do that.

I just checked a CentOS5.2 running PG and there it is:

$ ls -l /tmp/.s.PGSQL.5432
srwxrwxrwx 1 postgres postgres 0 Oct 13 01:22 /tmp/.s.PGSQL.5432

.TM.