X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 926B932A0AE; Thu, 30 Sep 2004 14:26:51 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 86610-07; Thu, 30 Sep 2004 13:26:44 +0000 (GMT) Received: from mr1.surnet.cl (av1.surnet.cl [216.155.73.168]) by svr1.postgresql.org (Postfix) with ESMTP id 2B05C32A16B; Thu, 30 Sep 2004 14:26:46 +0100 (BST) Received: from smtp1.surnet.cl (216.155.73.168) by mr1.surnet.cl (7.0.024) id 413F2C37003BBB70; Thu, 30 Sep 2004 09:26:23 -0400 Received: from av2.surnet.cl ([216.155.73.169]) by smtp1.surnet.cl (MailMonitor for SMTP v1.2.2 ) ; Thu, 30 Sep 2004 09:26:23 -0400 (CLT) Received: from cluster.surnet.cl (216.155.73.165) by smtp2.surnet.cl (7.0.024) id 415C07190000099A; Thu, 30 Sep 2004 09:23:25 -0400 Received: from 216.155.88.75.dsl.surnet.cl (216.155.71.145) by cluster.surnet.cl (7.0.024) (authenticated as alvherre@surnet.cl) id 4134D3220035063E; Thu, 30 Sep 2004 09:26:29 -0400 Received: by 216.155.88.75.dsl.surnet.cl (Postfix, from userid 500) id 62EC53270; Thu, 30 Sep 2004 09:26:29 -0400 (CLT) Date: Thu, 30 Sep 2004 09:26:29 -0400 From: Alvaro Herrera To: "Marc G. Fournier" Cc: Josh Berkus , pgsql-advocacy@postgresql.org, Bruce Momjian , PostgreSQL www Subject: Re: [pgsql-advocacy] Server unreliability Message-ID: <20040930132629.GC4783@dcc.uchile.cl> References: <200409291713.i8THDLn14086@candle.pha.pa.us> <200409291152.05741.josh@agliodbs.com> <20040929155958.U93533@ganymede.hub.org> <20040929201556.GB5275@dcc.uchile.cl> <20040929202326.Q3407@ganymede.hub.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20040929202326.Q3407@ganymede.hub.org> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_DSBL X-Spam-Level: * X-Archive-Number: 200409/277 X-Sequence-Number: 5347 On Wed, Sep 29, 2004 at 08:24:31PM -0300, Marc G. Fournier wrote: > On Wed, 29 Sep 2004, Alvaro Herrera wrote: > > >about pg_query not getting a good connection or similar problems. > >Isn't normal advice to check return codes before even trying to use the > >connections? Why isn't this done in the main postgresql.org code, where > >anyone can see it, is beyond me. Of course the solution to the > >underlying problem is to restart the Postgres server, but why should we > >inform the user that Postgres' own database server is down, in the worst > >possible way? > > Just curious here, but when/where? I don't remember an exact date or place, just that I've seen that happen more than three times and I've always thought it was bad programming practice. It has been very annoying, mainly because it means casual visitors could see those and possible think Postgres reliability sucked. Perhaps it has been fixed since then. -- Alvaro Herrera () "The important things in the world are problems with society that we don't understand at all. The machines will become more complicated but they won't be more complicated than the societies that run them." (Freeman Dyson)