Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: unknown_filename
Description: text/html (2.0 KB)

Responses

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group