If I type: psql waterdb I must login as postgres user.
So what can I do to login using phpPgAdmin 3.0.1?
*******************************************************
Tran Anh Tu
Vien CNTT - DHQG Ha Noi
Phone: 047680417-25 Email trantu@vnu.edu.vn
*******************************************************
-----Original Message-----
From: "Kent L. Nasveschuk" <kent@wareham.k12.ma.us>
To: Tran Anh Tu <trantu@vnu.edu.vn>
Cc: Postgres-Admin list <pgsql-admin@postgresql.org>
Date: 13 Sep 2003 21:27:39 -0400
Subject: Re: [PHP] Help me
> 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>
> .