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@xxxxxxxxxx ******************************************************* -----Original Message----- From: "andhie adam" <andhie@xxxxxxxxxxxxx> To: "Tran Anh Tu" <trantu@xxxxxxxxxx> 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 <ENTER> > 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