X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7AA4C474E61 for ; Thu, 27 Feb 2003 07:52:59 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 98752-03 for ; Thu, 27 Feb 2003 07:52:48 -0500 (EST) Received: from dristor.cabanova.ro (cabanova.ro [213.157.162.113]) by postgresql.org (Postfix) with SMTP id 1AC5D475A71 for ; Thu, 27 Feb 2003 07:51:41 -0500 (EST) Received: (qmail 4850 invoked from network); 27 Feb 2003 12:55:13 -0000 Received: from catalin.dristor.cabanova.ro (HELO catalin) (192.168.1.2) by dristor.cabanova.ro with SMTP; 27 Feb 2003 12:55:13 -0000 Message-ID: <00da01c2de5f$04154f40$0201a8c0@catalin> From: "Catalin" To: References: <3E5E50B8.10803.E998B57@localhost> Subject: Re: Daily crash Date: Thu, 27 Feb 2003 14:51:59 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Spam-Rating: dristor.cabanova.ro 1.6.2 0/1000/N X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/227 X-Sequence-Number: 1283 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... Catalin ----- Original Message ----- From: Shridhar Daithankar To: pgsql-performance@postgresql.org Sent: Thursday, February 27, 2003 2:24 PM Subject: Re: [PERFORM] Daily crash On 27 Feb 2003 at 14:19, Catalin wrote: > Is there any performance tunning that i can make to the postgresql server to > make the server more stable. > In my case the main usage of the DB is from an website which has quite lots > of visitors. > In the last weeks the SQL server crashes every day ! Could you please post the database logs? This is weird as far as I can guess. Bye Shridhar -- I'm frequently appalled by the low regard you Earthmen have for life. -- Spock, "The Galileo Seven", stardate 2822.3 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html