From: | Kai-Martin <kmk(at)familieknaak(dot)de> |
---|---|
To: | Postgres-Novice Mailinglist <pgsql-novice(at)postgresql(dot)org> |
Subject: | Cannot connect although server is running |
Date: | 2009-04-05 21:05:19 |
Message-ID: | 1238965519.9878.0@kwak |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I posted this to comp.databases.postgresql before but got no answers yet.
Traffic seems to be pretty low over there. So here
/--------------------
Since about a month I can't connect to my local postgres server
any more.
$ psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
However, the server seems to be running fine:
$ ps aux |grep postgresql
postgres 11406 0.0 0.2 21812 3960 ? S 06:24 0:00 /usr/lib/
postgresql/8.1/bin/postmaster -D /var/lib/postgresql/8.1/main -c
config_file=/etc/postgresql/8.1/main/postgresql.conf
$ sudo /etc/init.d/postgresql-8.1 status
8.1 main 5432 online postgres /var/lib/postgresql/8.1/
main /var/log/postgresql/postgresql-8.1-main.log
In /etc/postgresql/8.1/main/pg_hba.conf I granted access to any local
user:
local all all trust
System is debian/squeeze
Any hints?
Maybe some kernel options set the wrong way? But the server does not work
connect with a vanilla 2.6 kernel from my distro, either. So I conclude, the
problem must be elsewhere.
---<(kaimartin)>---
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-04-05 21:29:22 | Re: Cannot connect although server is running |
Previous Message | Just E. Mail | 2009-04-05 16:39:59 | Re: Error installing PostgreSQL |