| From: | admin <mick(at)mjhall(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Starting PostgreSQL |
| Date: | 2008-10-11 14:33:20 |
| Message-ID: | 48F0B930.5040900@mjhall.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Devrim GÜNDÜZ | 2008-10-11 16:35:58 | Re: Starting PostgreSQL |
| Previous Message | Ivan Sergio Borgonovo | 2008-10-11 13:11:43 | Re: drupal 6.x fixes for PostgreSQL 8.3 available |