Login as the postgres user to phpPgAdmin user, and create a new user for yourself. Also, set a password for the postgres user. Then, edit your pg_hba.conf and set password access to 'md5', not 'trust'. Chris On Sun, 14 Sep 2003, Tran Anh Tu wrote: > 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@xxxxxxxxxx > ******************************************************* > > > -----Original Message----- > From: "Kent L. Nasveschuk" <kent@xxxxxxxxxxxxxxxxx> > To: Tran Anh Tu <trantu@xxxxxxxxxx> > Cc: Postgres-Admin list <pgsql-admin@xxxxxxxxxxxxxx> > 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@xxxxxxxxxx > > > ******************************************************* > > > > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > > TIP 5: Have you checked our extensive FAQ? > > > > > > http://www.postgresql.org/docs/faqs/FAQ.html > > -- > > Kent L. Nasveschuk <kent@xxxxxxxxxxxxxxxxx> > > . > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >
