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 [EMAIL PROTECTED] > ******************************************************* > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html -- Kent L. Nasveschuk <[EMAIL PROTECTED]> . ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend