X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D41C432A552 for ; Tue, 5 Oct 2004 07:06:20 +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 83743-08 for ; Tue, 5 Oct 2004 06:06:14 +0000 (GMT) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 97A7132A547 for ; Tue, 5 Oct 2004 07:06:11 +0100 (BST) Received: (qmail 5265 invoked by uid 65534); 5 Oct 2004 06:06:09 -0000 Received: from dsl-213-023-249-149.arcor-ip.net (EHLO colt.pezone.net) (213.23.249.149) by mail.gmx.net (mp027) with SMTP; 05 Oct 2004 08:06:09 +0200 X-Authenticated: #495269 From: Peter Eisentraut To: John Allgood , pgsql-admin@postgresql.org Subject: Re: Failover Solution for Postgres Date: Tue, 5 Oct 2004 08:06:07 +0200 User-Agent: KMail/1.5.1 References: <41619B28.5010707@turbocorp.com> In-Reply-To: <41619B28.5010707@turbocorp.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200410050806.07961.peter_e@gmx.net> 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/90 X-Sequence-Number: 15083 John Allgood wrote: > I am looking for information on postgres failover solutions. Set up two machines with shared storage and have the machine monitor each other with heartbeat. If you don't want to invest in shared storage hardware, set up DRBD to replicate the file system between the two. (I think the Red Hat cluster mentioned elsewhere amounts to the first variant, more or less.) -- Peter Eisentraut http://developer.postgresql.org/~petere/