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 9765952956 for ; Wed, 20 Jul 2005 18:58:09 -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 74021-06 for ; Wed, 20 Jul 2005 21:58:06 +0000 (GMT) Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.201]) by svr1.postgresql.org (Postfix) with ESMTP id 4E78D52943 for ; Wed, 20 Jul 2005 18:58:05 -0300 (ADT) Received: by nproxy.gmail.com with SMTP id g2so409699nfe for ; Wed, 20 Jul 2005 14:58:07 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=WDolIF7/XmF1l/b6hnjkmoYGw0pvGx0QxL5MHteSlbL9QMMdnUmmcyYRcTyJ6FWBeCRZlwiv27yBWsw6+SJt5Xu0738uzN92DHaYGK8pR5arfv83qNsKr80/GfGxDeYFUY+GGFKMCIuC5BzPBqyDjtxVBhRr22c5p3fh8DTj/ug= Received: by 10.48.143.9 with SMTP id q9mr34029nfd; Wed, 20 Jul 2005 14:58:07 -0700 (PDT) Received: by 10.48.144.16 with HTTP; Wed, 20 Jul 2005 14:58:06 -0700 (PDT) Message-ID: Date: Wed, 20 Jul 2005 22:58:06 +0100 From: Guido Barosio Reply-To: Guido Barosio To: Tsirkin Evgeny Subject: Re: can not start the postgresql, i use gentoo Cc: Andy , guo weidong , pgsql-admin@postgresql.org In-Reply-To: <42DE0386.5090904@mail.jct.ac.il> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_9235_16292923.1121896686947" References: <20050720033010.43842.qmail@web34111.mail.mud.yahoo.com> <004c01c58cfb$0b996790$0b00a8c0@forge> <42DE0386.5090904@mail.jct.ac.il> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.25 tagged_above=0 required=5 tests=AWL, HTML_30_40, HTML_MESSAGE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200507/167 X-Sequence-Number: 18223 ------=_Part_9235_16292923.1121896686947 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Those PG* parameters are env things, that you should export in your profile= ,=20 and that's why the postgresql.conf is not a valid .conf file.=20 Move them out the conf file, read about ...bash? and the manual page=20 regarding administration / installation of postgresql. Regards, Guido On 7/20/05, Tsirkin Evgeny wrote:=20 >=20 >=20 > Just guessing : > The guy probably posted a conf file used by gentoo internaly NOT > /var/lib/pgsql/data/postgresql.conf . >=20 > Andy wrote: >=20 > > # PostgreSQL's Database Directory > > PGDATA=3D/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=3D/var/lib/postgresql/data > >> > >> # Logfile path: (NOTE: This must be uid/gid owned by > >> the value of $PGUSER!) > >> PGLOG=3D/var/lib/postgresql/data/postgresql.log > >> > >> # Run the PostgreSQL user as: > >> PGUSER=3Dpostgres > >> > >> # Extra options to run postmaster with. > >> # If you want to enable TCP/IP for PostgreSQL, add -i > >> to the following: > >> PGOPTS=3D"-N 1024 -B 2048 -i" > >> > >> #tcpip_socket =3D true > >> > >> > >> > >> ____________________________________________________ > >> Start your day with Yahoo! - make it your home page > >> http://www.yahoo.com/r/hs > >> > >> > >> ---------------------------(end of=20 > 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 >=20 >=20 >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >=20 --=20 "Adopting the position that you are smarter than an automatic optimization algorithm is generally a good way to achieve less performance, not more" - Tom Lane. ------=_Part_9235_16292923.1121896686947 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Those PG* parameters are env things, that you should export in your pr= ofile, and that's why
the postgresql.conf is not a valid .conf file.
 
Move them out the conf file, read about ...bash? and the manual page r= egarding administration / installation of postgresql.
 
Regards,
Guido

 
On 7/20/05, = Tsirkin Evgeny <tsurkin@ma= il.jct.ac.il> wrote:

Just guessing :
The guy p= robably posted a conf file used by gentoo internaly NOT
/var/lib/pgsql/d= ata/postgresql.conf .

Andy wrote:

> # PostgreSQL's Database Directory
> P= GDATA=3D/var/lib/postgresql/data
>
> Is this all you have in th= e postgresql.conf file??? That file is
> usually full with settings(m= ost of them optional) but still...
> Are u sure?
>
> Andy.
>
> ----- Original M= essage ----- From: "guo weidong" <gwd1122331@yahoo.com>
> To: < pgsql-admin@postgresql.org>
> Sent: Wednesday, July 20, 2005 6= :30 AM
> Subject: [ADMIN] can not start the postgresql, i use gentoo<= br>>
>
>> 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/po= stgresql.log [ !! ]
>>
>> and my postgresql.log is
>= ;>
>> FATAL: syntax error in file
>> "/var/lib/po= stgresql/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
>>
>> # PostgreS= QL's Database Directory
>> PGDATA=3D/var/lib/postgresql/data
>>
>> # Lo= gfile path: (NOTE: This must be uid/gid owned by
>> the value of $= PGUSER!)
>> PGLOG=3D/var/lib/postgresql/data/postgresql.log
>= ;>
>> # Run the PostgreSQL user as:
>> PGUSER=3Dpostgres>>
>> # Extra options to run postmaster with.
>> #= If you want to enable TCP/IP for PostgreSQL, add -i
>> to the fol= lowing:
>> PGOPTS=3D"-N 1024 -B 2048 -i"
>>
>>= ; #tcpip_socket =3D true
>>
>>
>>
>> __= __________________________________________________
>> Start your d= ay with Yahoo! - make it your home page
>> http://www.yahoo.com/r/h= s
>>
>>
>> ---------------------------(end o= f broadcast)---------------------------
>> TIP 4: Have you searche= d our list archives?
>>
>>        &nb= sp;      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
>     &nb= sp; match



---------------------------(end of broadcast)-----= ----------------------
TIP 5: don't forget to increase your free space map settings



--
"Adopting the position that you are sma= rter than an automatic
optimization algorithm is generally a good way to= achieve less
performance, not more" - Tom Lane.=20 ------=_Part_9235_16292923.1121896686947--