X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 07BF8475458 for ; Thu, 27 Feb 2003 08:02:44 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 99222-05 for ; Thu, 27 Feb 2003 08:02:33 -0500 (EST) Received: from www.pspl.co.in (www.pspl.co.in [202.54.11.65]) by postgresql.org (Postfix) with ESMTP id 1C1D1474E5C for ; Thu, 27 Feb 2003 08:02:31 -0500 (EST) Received: (from root@localhost) by www.pspl.co.in (8.11.6/8.11.6) id h1RD2Xh13279 for ; Thu, 27 Feb 2003 18:32:33 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) by www.pspl.co.in (8.11.6/8.11.0) with ESMTP id h1RD2Xf13273 for ; Thu, 27 Feb 2003 18:32:33 +0530 From: "Shridhar Daithankar" To: Date: Thu, 27 Feb 2003 18:33:15 +0530 MIME-Version: 1.0 Subject: Re: Daily crash Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3E5E59EB.26039.EBD7DCB@localhost> In-reply-to: <00da01c2de5f$04154f40$0201a8c0@catalin> X-mailer: Pegasus Mail for Windows (v4.02) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/228 X-Sequence-Number: 1284 On 27 Feb 2003 at 14:51, Catalin wrote: > i'm afraid i don't have any logs. > i have the default redhat instalation of postgres 7.0.2 which comes with no > logging enabled. > > i will try to enable logging and post the logs to the list ! > > anyway in PHP when trying to connect to the crashed SQL server i get the > error message: > Too many connections... Tell me. Does that sound like a crash? To me the server is well alive. And if you are using default configuration, you must be experiencing a real pathetic performance for a real world load. Try tuning the database. There are too many tips to put in one place. but editing /var/lib/data/postgresql/postgresql.conf ( I hope I am right, I am too used to do pg_ctl by hand. Never used services provided by disro.s) is first step. You need to read the admin guide as well. HTH Bye Shridhar -- Glib's Fourth Law of Unreliability: Investment in reliability will increase until it exceeds the probable cost of errors, or until someone insists on getting some useful work done.