Re: can not start the postgresql, i use gentoo

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" <gwd1122331(at)yahoo(dot)com>
> To: <pgsql-admin(at)postgresql(dot)org>
> 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