Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DB start error

Status
Not open for further replies.

solaroot

Programmer
Dec 6, 2004
1
US
Why am i receiving the 'FATAL' error when starting the database. Please see below.
Solaroot.


Success. You can now start the database server using:

/usr/bin/postmaster -D /usr/local/pgsql/data
or
/usr/bin/pg_ctl -D /usr/local/pgsql/data -l
logfile start

bash-2.05b$ postmaster -d /usr/local/pgsql/data
FATAL: invalid value for option
'server_min_messages': 'debug/usr/local/pgsql/data'
bash-2.05b$ /usr/bin/postmaster -d
/usr/local/pgsql/data
FATAL: invalid value for option
'server_min_messages': 'debug/usr/local/pgsql/data'
bash-2.05b$
 
Here is the line from rc.local that runs postmaster for me:

postmaster -i -D /var/
The -i is to allow TCP/IP connections (which you may or may not need, and probably shouldn't give that kind of error)

What kind of permissions do you have on your /usr/local/pgsql/data directory?

My data directory is chmod 700, owned by postgres:root
(Postgres is the user under which the postmaster runs, I assume its probably the same for your system)

Hope that helps,
MG
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top