X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 42F845286A for ; Wed, 20 Jul 2005 04:15:10 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94433-10 for ; Wed, 20 Jul 2005 07:15:05 +0000 (GMT) Received: from ar-sd.net (unknown [82.77.155.72]) by svr1.postgresql.org (Postfix) with ESMTP id 072585287E for ; Wed, 20 Jul 2005 04:15:04 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ar-sd.net (Postfix) with ESMTP id 8C36F2DD74; Wed, 20 Jul 2005 10:06:33 +0300 (EEST) Received: from ar-sd.net ([127.0.0.1]) by localhost (linz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21915-09; Wed, 20 Jul 2005 10:06:29 +0300 (EEST) Received: from forge (unknown [192.168.0.11]) by ar-sd.net (Postfix) with SMTP id 84E262DD73; Wed, 20 Jul 2005 10:06:29 +0300 (EEST) Message-ID: <004c01c58cfb$0b996790$0b00a8c0@forge> From: "Andy" To: "guo weidong" , References: <20050720033010.43842.qmail@web34111.mail.mud.yahoo.com> Subject: Re: can not start the postgresql, i use gentoo Date: Wed, 20 Jul 2005 10:16:26 +0300 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at ar-sd.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.274 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200507/142 X-Sequence-Number: 18198 # PostgreSQL's Database Directory PGDATA=/var/lib/postgresql/data Is this all you have in the postgresql.conf file??? That file is usually full with settings(most of them optional) but still... Are u sure? Andy. ----- Original Message ----- From: "guo weidong" To: Sent: Wednesday, July 20, 2005 6:30 AM Subject: [ADMIN] can not start the postgresql, i use gentoo >I can not run start the postgresql service, and spent > several days can not solve the problem. thanks for > anyone who can help me . > :oops: :oops: :oops: :oops: :oops: > /etc/init.d/postgresql start > * Starting PostgreSQL ... > * Please see log file: > /var/lib/postgresql/data/postgresql.log [ !! ] > > and my postgresql.log is > > FATAL: syntax error in file > "/var/lib/postgresql/data/postgresql.conf" line 2, > near token "/" > > I dont'n know what is wrong with the postgresql.conf > > Here is the config file > postgresql.conf > > # PostgreSQL's Database Directory > PGDATA=/var/lib/postgresql/data > > # Logfile path: (NOTE: This must be uid/gid owned by > the value of $PGUSER!) > PGLOG=/var/lib/postgresql/data/postgresql.log > > # Run the PostgreSQL user as: > PGUSER=postgres > > # Extra options to run postmaster with. > # If you want to enable TCP/IP for PostgreSQL, add -i > to the following: > PGOPTS="-N 1024 -B 2048 -i" > > #tcpip_socket = true > > > > ____________________________________________________ > Start your day with Yahoo! - make it your home page > http://www.yahoo.com/r/hs > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > >