Re: Help me

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(at)vnu(dot)edu(dot)vn
> *******************************************************
>
>
> -----Original Message-----
> From: "Kent L. Nasveschuk" <kent(at)wareham(dot)k12(dot)ma(dot)us>
> To: Tran Anh Tu <trantu(at)vnu(dot)edu(dot)vn>
> Cc: Postgres-Admin list <pgsql-admin(at)postgresql(dot)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(at)vnu(dot)edu(dot)vn
> > > *******************************************************
> > >
> > >
> > > ---------------------------(end of
> > broadcast)---------------------------
> > > TIP 5: Have you checked our extensive FAQ?
> > >
> > > http://www.postgresql.org/docs/faqs/FAQ.html
> > --
> > Kent L. Nasveschuk <kent(at)wareham(dot)k12(dot)ma(dot)us>
> > .
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>