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 6EF12D1B52F for ; Fri, 12 Sep 2003 09:10:06 +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 39090-01 for ; Fri, 12 Sep 2003 06:09:57 -0300 (ADT) Received: from vnu.edu.vn (mail.vnu.edu.vn [203.113.130.199]) by svr1.postgresql.org (Postfix) with ESMTP id 8C30AD1B50A for ; Fri, 12 Sep 2003 06:09:53 -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 52-md50000000156.tmp for ; Fri, 12 Sep 2003 16:08:18 +0700 Received: from [10.6.1.63] via WorldClient with HTTP; Fri, 12 Sep 2003 16:08:18 +0700 Date: Fri, 12 Sep 2003 16:08:18 +0700 From: "Tran Anh Tu" To: "andhie adam" , Subject: Re: Help me Message-ID: X-Mailer: WorldClient 6.8.4 In-Reply-To: <20030912073621.32029.qmail@linuxmail.org> References: <20030912073621.32029.qmail@linuxmail.org> X-Authenticated-Sender: trantu@vnu.edu.vn X-Spam-Processed: vnu.edu.vn, Fri, 12 Sep 2003 16:08:18 +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/35 X-Sequence-Number: 2312 It's OK.Thank you for your help. Best wishes to you. ******************************************************* Tran Anh Tu Vien CNTT - DHQG Ha Noi Phone: 047680417-25 Email trantu@vnu.edu.vn ******************************************************* -----Original Message----- From: "andhie adam" To: "Tran Anh Tu" Date: Fri, 12 Sep 2003 15:36:21 +0800 Subject: Re: [PHP] Help me > > >Hi all! > >Postgresql is installed automatically with rpm packets, It run > perfectly > >with command : /etc/init.d/postgresql start > >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. > >You must specify the directory that contains the database system > >either by specifying the -D invocation option or by setting the > >PGDATA environment variable. > > >Please help me! > > if your postgresql is installed automatically with rpm packets. > before you start the postmaster, you must do it some steps like this... > 1. from root, you must login as postgres superuser with command " su > postgres" > # su postgres > 2. the next steps you must create database cluster, the command like > this... > $ initdb -D /var/lib/pgsql/data > 3. the finally steps, now you can start the postmaster (from postgres > super user) > like this... > $ postmaster -i -D /var/lib/pgsql/data > > I hope, my answer can help you > > regards > Andhie > > -- > ______________________________________________ > http://www.linuxmail.org/ > Now with e-mail forwarding for only US$5.95/yr > > Powered by Outblaze