X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id AEE19D1B504 for ; Fri, 12 Sep 2003 09:51:13 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 47049-03 for ; Fri, 12 Sep 2003 06:51:05 -0300 (ADT) Received: from vnu.edu.vn (mail.vnu.edu.vn [203.113.130.199]) by svr1.postgresql.org (Postfix) with ESMTP id 4E133D1B4EB for ; Fri, 12 Sep 2003 06:51:01 -0300 (ADT) Received: from WorldClient ([127.0.0.1]) (authenticated user trantu@vnu.edu.vn) by vnu.edu.vn (vnu.edu.vn [203.113.130.199]) (MDaemon.PRO.v6.8.4.R) with ESMTP id 63-md50000000157.tmp for ; Fri, 12 Sep 2003 16:49:38 +0700 Received: from [10.6.1.63] via WorldClient with HTTP; Fri, 12 Sep 2003 16:49:38 +0700 Date: Fri, 12 Sep 2003 16:49:38 +0700 From: "Tran Anh Tu" To: "Kent L. Nasveschuk" , Subject: Re: Help me Message-ID: X-Mailer: WorldClient 6.8.4 In-Reply-To: <1063358556.2039.7.camel@1134> References: <3F616FC5.8010805@MplusB.de> <1063358556.2039.7.camel@1134> X-Authenticated-Sender: trantu@vnu.edu.vn X-Spam-Processed: vnu.edu.vn, Fri, 12 Sep 2003 16:49:38 +0700 (not processed: message from valid local sender) X-MDRemoteIP: 127.0.0.1 X-Return-Path: trantu@vnu.edu.vn X-MDaemon-Deliver-To: pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/36 X-Sequence-Number: 2313 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" To: Tran Anh Tu 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 > > To: Tran Anh Tu > > 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