Re: DB problem

> 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