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 C01CA529D3 for ; Wed, 20 Jul 2005 04:52:05 -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 04182-07 for ; Wed, 20 Jul 2005 07:51:59 +0000 (GMT) Received: from mail2.cc.huji.ac.il (real-outmail.cc.huji.ac.il [132.64.1.18]) by svr1.postgresql.org (Postfix) with ESMTP id 44E0A529AD for ; Wed, 20 Jul 2005 04:51:58 -0300 (ADT) Received: from mail2.cc.huji.ac.il (localhost [127.0.0.1]) by mail2.cc.huji.ac.il (Postfix) with SMTP id 5024F1DF1FE; Wed, 20 Jul 2005 10:51:59 +0300 (IDT) Received: by mail2.cc.huji.ac.il (Postfix, from userid 31998) id 498E11DBE82; Wed, 20 Jul 2005 10:51:59 +0300 (IDT) Received: from [132.64.52.127] (evegeni.mm.huji.ac.il [132.64.52.127]) by mail2.cc.huji.ac.il (Postfix) with ESMTP id 88D8B1DF207; Wed, 20 Jul 2005 10:51:56 +0300 (IDT) Message-ID: <42DE0386.5090904@mail.jct.ac.il> Date: Wed, 20 Jul 2005 10:55:50 +0300 From: Tsirkin Evgeny User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Andy Cc: guo weidong , pgsql-admin@postgresql.org Subject: Re: can not start the postgresql, i use gentoo References: <20050720033010.43842.qmail@web34111.mail.mud.yahoo.com> <004c01c58cfb$0b996790$0b00a8c0@forge> In-Reply-To: <004c01c58cfb$0b996790$0b00a8c0@forge> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus: scanned by VAMS 2005 version 8.800 from Tue Jul 19 16:15:35 2005 CEST X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/144 X-Sequence-Number: 18200 Just guessing : The guy probably posted a conf file used by gentoo internaly NOT /var/lib/pgsql/data/postgresql.conf . Andy wrote: > # 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 >> >> > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match