Since about a month I can't connect to the 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?

---<(kaimartin)>---

Kai-Martin Knaak <kmk (AT) lilalaser (DOT) de> wrote:
search for this file and/or specify the location with
unix_socket_directory = ... in your postgresql.conf.

Other solution: start psql with the parameters -h localhost and -p 5432
to force a tcp/ip - connection.



Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net