Re: Help me - Mailing list pgsql-php

Yes, because I begin at learning Posgresql so have lots thing that I
don't understand for. I hope I will receive your help. Thank you very
much.
*******************************************************
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>
Date: 12 Sep 2003 05:22:37 -0400
Subject: Re: [PHP] Help me

> I believe that root user is not in the system catalog as a user. The
> default user that Postgres installs is postgres. If you log in as that
> user or change your user context to postgres you should have full
> rights
> from the local machine by default. As the user "postgres" you can
> create
> additional users with the command /{install path}/pgsql/bin/createuser.
> Also you can alter user from the psql prompt.
>
>
> Kent N
>
> On Fri, 2003-09-12 at 03:27, Tran Anh Tu wrote:
> > I had checked the directory:
> > /var/lib/pgsql (not postgres)
> > It has some files but I can't do with it. I thought I had a prolems
> when
> > install mandrake 9.0 and I installed it again but there is nothing to
> be
> > change.
> > When I start postgresql by the command:
> >    /etc/init.d/postgresql start
> > then I type with user root:
> >    createdb demo
> > Have a error message:
> >    user "root" does not exist
> > What does this mean? please help me, thank you very much.
> > *******************************************************
> > Tran Anh Tu
> > Vien CNTT - DHQG Ha Noi
> > Phone: 047680417-25   Email trantu@vnu.edu.vn
> > *******************************************************
> >
> >
> > -----Original Message-----
> > From: Gerd Terlutter <gerd@MplusB.de>
> > To: Tran Anh Tu <trantu@vnu.edu.vn>
> > Cc: pgsql-php@postgresql.org
> > Date: Fri, 12 Sep 2003 09:03:33 +0200
> > Subject: Re: [PHP] Help me
> >
> > > Tran Anh Tu wrote:
> > > > Hi all!
> > >
> > > ...
> > > > But when I stop it and switch to user: postgres, and start it
> with
> > > > command: postmaster -i then it does not working because It don't
> know
> > > > where the database is placed. A error message:
> > > >
> > > > postmaster does not know where to find the database system data.
> > > > Please help me!
> > > tran@tux$su -
> > > password:xxx
> > > root#su postgres
> > > tux:/root$ whoami
> > > postgres
> > > tux:/root$ cd
> > > tux$pwd
> > > /var/lib/postgres
> > > tux$ls -al
> > > does this help?
> > >
> > > greetings,
> > > Gerd
> > >
> > > --
> > > --------------------------------------------------------
> > > # Gerd Terlutter        | Mueller+Blanck Software GmbH #
> > > # gerd@MplusB.de        | Gutenbergring 38             #
> > > # gerd.terlutter@web.de | D-22848 Noderstedt           #
> > > # tel:0171/6992579      | tel:+49 40 500 171-1         #
> > > # Buero:040/500171-17   | fax:+49 40 500 171-71        #
> > > --------------------------------------------------------
> > >
> > >
> > >
> > > ---------------------------(end of
> > > broadcast)---------------------------
> > > TIP 7: don't forget to increase your free space map settings
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 7: don't forget to increase your free space map settings
> --
> Kent L. Nasveschuk <kent@wareham.k12.ma.us>