Thread: I can't use pgsql with my main user session on Linux

Hello,

I just installed postgresql 7.4 using Synaptic with Ubuntu Breezy
(i386) and I have a problem with my main Linux account.

I have created 3 users in postgresql: tobini (main), hadoc and postgres
(main postgresql account).

First using the postgres account I created 2 postgresql users for the
database : tobini and hadoc.

I can open databases using postgres and hadoc but I have an error with
the tobini session : pgsql returns an error asking to check if
postgresql accepts connexions using the
var/run/postgresql/.s.PGSQL.5432 socket but with Ubuntu package the
socket is in /tmp/.s.PGSQL.5432 (???). That's exactly the same error
when trying to connect from perl DBI using a wrong socket path.

I really don't uderstand.

Do you have an idea ?

Thanks.

C. Tobini