> We are using PostgreSQL 7.3 version, installed in linux > system. Only DB is getting shut down 3-4 times a day. From my > application end I get "Sorry too many clients" error. > Refering the FAQ I maximized the DB session limit to 200. > > I think the logs are not enabled in my DB. So I set the > following options in postgresql.con file > > log_timestamp= true > log_directory=pg_log > log_filename=%Y-%m-%d_%H%M%S.log > log_disconnections=true > log_hostname=true > log_statement=true > > > After restarting the system got the following error : > FATAL: postgresql.conf:131: syntax error, token="%" > FATAL: postgresql.conf:131: syntax error, token="%" > FATAL: postgresql.conf:131: syntax error, token="%" > FATAL: 'log_directory' is not a valid option name > FATAL: 'log_directory' is not a valid > FATAL: 'log_filename' is not a valid option name > FATAL: 'log_disconnections' is not a valid option name > > When you install the DB, the logs are enabled by default? > > Would you pls tell me still what setting need to be done?
You can see in the documentation: http://www.postgresql.org/docs/7.3/static/runtime-config.html#LOGGING The parameters you used are for a different version of PostgreSQL. Yours, Laurenz Albe ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
