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 D1EC632A2F2 for ; Sat, 2 Oct 2004 21:08:50 +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 65605-02 for ; Sat, 2 Oct 2004 20:08:45 +0000 (GMT) Received: from hub.org (hub.org [200.46.204.220]) by svr1.postgresql.org (Postfix) with ESMTP id 23E6032A2F1 for ; Sat, 2 Oct 2004 21:08:46 +0100 (BST) Received: from localhost (unknown [200.46.204.144]) by hub.org (Postfix) with ESMTP id 833EE48FE7F for ; Sat, 2 Oct 2004 17:08:43 -0300 (ADT) Received: from hub.org ([200.46.204.220]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63398-10; Sat, 2 Oct 2004 20:08:40 +0000 (GMT) Received: from ganymede.hub.org (blk-222-46-91.eastlink.ca [24.222.46.91]) by hub.org (Postfix) with ESMTP id 5EF5B48FE7C; Sat, 2 Oct 2004 17:08:39 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id E61F0376D1; Sat, 2 Oct 2004 17:08:40 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id E506337455; Sat, 2 Oct 2004 17:08:40 -0300 (ADT) Date: Sat, 2 Oct 2004 17:08:40 -0300 (ADT) From: "Marc G. Fournier" X-X-Sender: scrappy@ganymede.hub.org To: Gavin Sherry Cc: Chris Ryan , PostgreSQL www Subject: Re: [pgsql-advocacy] Server unreliability In-Reply-To: Message-ID: <20041002170759.Y64687@ganymede.hub.org> 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; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/26 X-Sequence-Number: 5420 Chris? Some extra error checking needed, maybe? On Sat, 2 Oct 2004, Gavin Sherry wrote: > On Wed, 29 Sep 2004, 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? We haven't had a database issue in >> quite awhile that *I'm* aware of ... in fact, the whole web site is >> static, generated periodically from .php files, so that the mirrors can >> pick things up properly, so there should never be a 'cannot connect to >> database' issue, since there are no connections to the database being made > > I know this isn't on the main site but: > > http://www.alcove.com.au/~swm/gborg.png > > Gavin > ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664