Are you connecting on the local machine? If so try without the -U and -p
ex.: psql waterdb
You can also use telnet or ssh and connect from a remote machine and do
the same.
Kent N
On Sat, 2003-09-13 at 21:23, Tran Anh Tu wrote:
> I started postgresql with command:
> /etc/init.d/postgresql start
> I created user 'trantu' with password 'hanoi' and this user have
> privileges fully to create database and create user.
> when I type a command:
> psql -U trantu -p hanoi
> or
> psql -U trantu -p hanoi waterdb
> have a same error:
> 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.0"?
>
> With phpPgAdmin, apache and php are configured perfecly.
> Please help me to debug it. Thank you very much.
> *******************************************************
> Tran Anh Tu
> Vien CNTT - DHQG Ha Noi
> Phone: 047680417-25 Email trantu@vnu.edu.vn
> *******************************************************
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
--
Kent L. Nasveschuk <kent@wareham.k12.ma.us>
.
