DB problem

From: vinayakr(at)vmoksha(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: DB problem
Date: 2006-12-26 10:36:14
Message-ID: OFEFC30C03.4C667CBF-ON65257250.003A3FCC-65257250.003A3FCD@vmoksha.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<FONT face="Default Sans Serif, Verdana, Arial, Helvetica, sans-serif" size=2><DIV><DIV><FONT face="Default Sans Serif, Verdana, Arial, Helvetica, sans-serif" size=2><DIV>Hi,</DIV><DIV>&nbsp;</DIV><DIV>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.&nbsp;<BR>Refering the FAQ I maximized the DB session limit to 200. </DIV><DIV>&nbsp;</DIV><DIV>I think the logs are not enabled in my DB. So I set the following options in postgresql.con file<BR>&nbsp;<BR>log_timestamp= true<BR>log_directory=pg_log&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR>log_filename=%Y-%m-%d_%H%M%S.log&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR>log_disconnections=true&nbsp;&nbsp;&nbsp;&nbsp; <BR>log_hostname=true&nbsp;&nbsp;&nbsp; </DIV><DIV>log_statement=true</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV><DIV>After&nbsp;restarting the system got the following error : </DIV><DIV>[root(at)localhost root]# su postgres bash-2.05b$ postmaster -i -D /var/lib/pgsql/data FATAL: postgresql.conf:131: syntax error, <BR>token="%" bash-2.05b$ postmaster -i -D /var/lib/pgsql/data FATAL: postgresql.conf:131: syntax error, token="%" bash-2.05b$ postmaster -i -D /var/lib/pgsql/data FATAL: postgresql.conf:131: syntax error, token="%" bash-2.05b$ postmaster -i -D /var/lib/pgsql/data FATAL: 'log_directory' is not a valid option name bash-2.05b$ postmaster -i -D /var/lib/pgsql/data FATAL: 'log_directory' is not a valid option name bash-2.05b$ postmaster -i -D /var/lib/pgsql/data FATAL: 'log_filename' is not a valid option name bash-2.05b$ postmaster -i -D /var/lib/pgsql/data FATAL: 'log_disconnections' is not a valid option name bash-2.05b$ postmaster -i -D /var/lib/pg</DIV><DIV><BR>When you install the DB, the logs are enabled by default?</DIV><DIV>&nbsp;</DIV><DIV>Would you pls tell me still what setting need to be done?</DIV><DIV>&nbsp;</DIV><DIV>Thanks,<BR>Vinayak&nbsp;V.&nbsp;Raikar<BR>Extn&nbsp;:&nbsp;143<BR><BR></DIV></FONT></DIV></DIV></FONT>

Attachment Content-Type Size
unknown_filename text/html 2.0 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message karthik 2006-12-26 10:43:17 could not open relation:no such file or directory
Previous Message Ilja Golshtein 2006-12-26 07:51:40 Re: table locks