Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 7A0F19F9F2C for ; Tue, 26 Dec 2006 05:42:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 41665-08 for ; Tue, 26 Dec 2006 05:42:26 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.179]) by postgresql.org (Postfix) with ESMTP id 2DDD29F93A2 for ; Tue, 26 Dec 2006 05:42:35 -0400 (AST) Received: by py-out-1112.google.com with SMTP id a73so1077141pye for ; Tue, 26 Dec 2006 01:42:34 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=EDPUNrThRe1UVRkC6nb4B0rgwrPQoWmP4g1kEKIvCwFEHVM8kQp6yyg4cEWzULPFFiEZ3ZsHXUl3jb5Dpzk+MlDTMcpHUC+vg8av8lSHm7mGp+g04B2Nhcjxc1aCBzk4IwWha2+jEEUM6OlnSl/klWl7Y73R2BUq9QKvKUpD78c= Received: by 10.35.18.18 with SMTP id v18mr8064698pyi.1167126154142; Tue, 26 Dec 2006 01:42:34 -0800 (PST) Received: by 10.35.33.2 with HTTP; Tue, 26 Dec 2006 01:42:34 -0800 (PST) Message-ID: <7be3f35d0612260142l2d94042ew3bcb3093a06b020c@mail.gmail.com> Date: Tue, 26 Dec 2006 10:42:34 +0100 From: "Harald Armin Massa" To: "vinayakr@vmoksha.com" Subject: Re: DB problem Cc: pgadmin-support@postgresql.org, pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/138 X-Sequence-Number: 6405 Vinayakr, > We are using PostgreSQL 7.3 version, installed in linux system. Only DB i= s > getting shut down 3-4 times a day. From my application end I get "Sorry t= oo > many clients" error. Maybe you should rise the maximum connections? > log_timestamp=3D true > log_directory=3Dpg_log > log_filename=3D%Y-%m-%d_%H%M%S.log > log_disconnections=3Dtrue > log_hostname=3Dtrue > log_statement=3Dtrue Your error clearly states that PostgreSQL cannot accept your postgresql.con= f >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 =3D 'pg_log'=09=09# Directory where log files are written =09=09=09=09=09# Can be absolute or relative to PGDATA log_filename =3D 'postgresql-%Y-%m-%d_%H%M%S.log' # Log file name pattern. =09=09=09=09=09# 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 enable= d. Best wishes, Harald --=20 GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstra=DFe 202b 70197 Stuttgart 0173/9409607 - Python: the only language with more web frameworks than keywords.