Cannot connect although server is running

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)>---

In response to

Responses

Browse pgsql-novice by date

  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