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 63DD7D1B576 for ; Thu, 11 Sep 2003 14:00:12 +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 41463-04 for ; Thu, 11 Sep 2003 10:59:43 -0300 (ADT) Received: from nebula.skynet.be (nebula.skynet.be [195.238.2.112]) by svr1.postgresql.org (Postfix) with ESMTP id 50896D1B4EC for ; Thu, 11 Sep 2003 10:59:39 -0300 (ADT) Received: from 95.8-136-217.adsl.skynet.be (95.8-136-217.adsl.skynet.be [217.136.8.95]) by nebula.skynet.be (8.12.9/8.12.9/Skynet-OUT-2.21) with ESMTP id h8BDxXPF024923 for ; Thu, 11 Sep 2003 15:59:33 +0200 (envelope-from ) Subject: Re: Help me From: Bastiaan Wakkie Reply-To: bwakkie@syrphidae.com To: pgsql-php@postgresql.org In-Reply-To: References: Content-Type: multipart/alternative; boundary="=-W9Awy4hjsbvT1u9cW0T2" Organization: www.syrphidae.com Message-Id: <1063201894.4596.3.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4-1.1mdk Date: 10 Sep 2003 15:51:34 +0200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/43 X-Sequence-Number: 2320 --=-W9Awy4hjsbvT1u9cW0T2 Content-Type: text/plain Content-Transfer-Encoding: 7bit Hi, This message you will get when you use the command as root. login as the postgres user: su - postgres then start: postmaster -D /var/pgsql/data -i >logfile 2>&1 & regards, Bastiaan On Thu, 2003-09-11 at 12:22, Tran Anh Tu wrote: > Hi all! > I have installed Mandr > ake 9.0. and postgresql is installed automatically. > When I start postgresql by the command: > postmaster -i > have a error message: > > The server must be started under an unprivileged user id to prevent > a possible system security compromise. See the documentation for > more information on how to properly start the server. > > With Mandrake 8.0, I do nothing to config postgresql. So what I can do to > config it now? Please help me! thank you very much. > ******************************************************* > Tran Anh Tu > Vien CNTT - DHQG Ha Noi > Phone: 047680417-25 Email trantu@vnu.edu.vn > ******************************************************* > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match -- Bastiaan Wakkie www.syrphidae.com --=-W9Awy4hjsbvT1u9cW0T2 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit Hi,

This message you will get when you use the command as root.

login as the postgres user:

   su - postgres

then start:

   postmaster -D /var/pgsql/data -i >logfile 2>&1 &

regards,
    Bastiaan

On Thu, 2003-09-11 at 12:22, Tran Anh Tu wrote:
Hi all!
I have installed Mandr
ake 9.0. and postgresql is installed automatically. 
When I start postgresql by the command: 
postmaster -i
have a error message:

The server must be started under an unprivileged user id to prevent
a possible system security compromise.  See the documentation for
more information on how to properly start the server.   

With Mandrake 8.0, I do nothing to config postgresql. So what I can do to 
config it now? Please help me! thank you very much.
*******************************************************
Tran Anh Tu
Vien CNTT - DHQG Ha Noi
Phone: 047680417-25   Email trantu@vnu.edu.vn
*******************************************************


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match
--
Bastiaan Wakkie <bastiaaw@dds.nl>
www.syrphidae.com
--=-W9Awy4hjsbvT1u9cW0T2--