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@xxxxxxxxx>
To: <pgsql-admin@xxxxxxxxxxxxxx>
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
