Re: DB problem

Vinayakr,

> 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.

Maybe you should rise the maximum connections?

> 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

Your error clearly states that PostgreSQL cannot accept your postgresql.conf

>FATAL: 'log_directory' is > not a valid option name bash-2.05b$
postmaster -i -D /var/lib/pgsql/data

strange ... within my config there is

# These are only used if redirect_stderr is on:
log_directory = 'pg_log' # Directory where log files are written
# Can be absolute or relative to PGDATA
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # Log file name pattern.
# Can include strftime() escapes

What I see that is missing within yours are the ' around the option values.

> When you install the DB, the logs are enabled by default?
That belongs to the packager. If he is reasonable sane, they will be enabled.

Best wishes,

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.