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 C41F4329CFD; Mon, 27 Sep 2004 08:54:04 +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 56019-02; Mon, 27 Sep 2004 07:53:59 +0000 (GMT) Received: from anchor-post-30.mail.demon.net (anchor-post-30.mail.demon.net [194.217.242.88]) by svr1.postgresql.org (Postfix) with ESMTP id 0954A329CE3; Mon, 27 Sep 2004 08:53:59 +0100 (BST) Received: from mailgate.vale-housing.co.uk ([80.176.1.146] helo=ratbert.vale-housing.co.uk) by anchor-post-30.mail.demon.net with esmtp (Exim 3.35 #1) id 1CBqKc-000PBb-0U; Mon, 27 Sep 2004 07:53:58 +0000 Content-class: urn:content-classes:message Subject: Re: Anything "time" critical on www.postgresql.org VM? MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Date: Mon, 27 Sep 2004 08:53:57 +0100 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [pgsql-www] Anything "time" critical on www.postgresql.org VM? Thread-Index: AcSj/0WEKRSNGD0aSPuOM361qUCrvgAZzzhQ From: "Dave Page" To: "Marc G. Fournier" , 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: 200409/178 X-Sequence-Number: 5248 =20 > -----Original Message----- > From: pgsql-www-owner@postgresql.org=20 > [mailto:pgsql-www-owner@postgresql.org] On Behalf Of Marc G. Fournier > Sent: 26 September 2004 20:30 > To: pgsql-www@postgresql.org > Subject: [pgsql-www] Anything "time" critical on=20 > www.postgresql.org VM? >=20 >=20 > I'd like to setup hot failover for that VM, so that if the=20 > server it is running on goes down, it will auto-come back up=20 > on a second server. So far, the finest I can get the=20 > replication granularity is 15 minutes, so there is the=20 > potential of 15 minutes worth of 'data' to be lost on a crash ... >=20 > As I believe that most (if not all?) of the stuff on that VM=20 > is pretty static as far as files, and there is no email over=20 > there, I can't think of any reason *not* to do this for that=20 > VM ... but, I wanted to check here to see if anyone knows of=20 > a reason that the potential lose of '15 minutes'=20 > worth of data is a bad thing? >=20 > If not, I'll get that setup ... >=20 > I don't believe that any of the other VMs can have this setup=20 > yet, until I can get the 'gap' reduced between replicas,=20 > since they are all dealing with CVS in some form or another,=20 > or email ... There's nothing time critical on there as far as the 'official' services go. Dunno if any of the users have any other tasks running that might be, but I doubt it. I say go for it! Regards, Dave