Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 7A0831337B5C for ; Fri, 17 Dec 2010 08:10:40 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 64191-04 for ; Fri, 17 Dec 2010 12:10:33 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from acidenitrix.villemain.org (acidenitrix.villemain.org [91.121.90.165]) by mail.postgresql.org (Postfix) with ESMTP id C171513364DE for ; Fri, 17 Dec 2010 08:10:32 -0400 (AST) Received: from 89-158-241-48.rev.dartybox.com ([89.158.241.48] helo=DimIMac.local) by acidenitrix.villemain.org with esmtpsa (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.69) (envelope-from ) id 1PTZ8o-0003JK-Q8; Fri, 17 Dec 2010 13:10:30 +0100 Received: by DimIMac.local (Postfix, from userid 501) id 1823D1447BF0; Fri, 17 Dec 2010 13:10:23 +0100 (CET) From: Dimitri Fontaine To: Benjamin Knoth Cc: pgsql-admin@postgresql.org Subject: Re: HA planning Organization: 2ndQuadrant References: <4D08CCF7.1090104@mpdl.mpg.de> User-Mail-Address: dimitri@2ndQuadrant.fr Date: Fri, 17 Dec 2010 13:10:22 +0100 In-Reply-To: <4D08CCF7.1090104@mpdl.mpg.de> (Benjamin Knoth's message of "Wed, 15 Dec 2010 15:13:11 +0100") Message-ID: User-Agent: Gnus/5.110011 (No Gnus v0.11) Emacs/24.0.50 (darwin) MIME-Version: 1.0 Content-Type: text/plain X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201012/116 X-Sequence-Number: 36345 Benjamin Knoth writes: > My first idea was to create a second VM. This vm get the same > configuration as the master system and some tools work to synchronize > both servers. But the realisation of HA it's more complex as i think. [...] > What solution would you prefer in my situation? Streaming Replication, possibly with Hot Standby http://www.postgresql.org/docs/9.0/interactive/warm-standby.html#STREAMING-REPLICATION http://www.postgresql.org/docs/9.0/interactive/hot-standby.html Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support