Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 32FD51336971 for ; Wed, 15 Dec 2010 10:32:46 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 20586-06 for ; Wed, 15 Dec 2010 14:32:39 +0000 (UTC) X-Greylist: delayed 00:18:51.00971 by SQLgrey-1.7.6 Received: from relay01.mpipf-muenchen.mpg.de (relay01.mpisoc.mpg.de [192.129.1.23]) by mail.postgresql.org (Postfix) with ESMTP id DD4B4133616B for ; Wed, 15 Dec 2010 10:32:38 -0400 (AST) Received: from mail01.intra.mpipf-muenchen.mpg.de ([10.1.1.41]) by relay01.mpipf-muenchen.mpg.de with esmtps (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1PSs6P-00024i-Ki for pgsql-admin@postgresql.org; Wed, 15 Dec 2010 15:13:45 +0100 Received: from b256.intra.mpipf-muenchen.mpg.de ([10.20.2.24]) by mail01.intra.mpipf-muenchen.mpg.de with esmtps (TLSv1:AES256-SHA:256) (Exim 4.67) (envelope-from ) id 1PSs6P-0006Fr-Hw for pgsql-admin@postgresql.org; Wed, 15 Dec 2010 15:13:09 +0100 Message-ID: <4D08CCF7.1090104@mpdl.mpg.de> Date: Wed, 15 Dec 2010 15:13:11 +0100 From: Benjamin Knoth User-Agent: Mozilla/5.0 (X11; U; Linux i686; de; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: HA planning Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/105 X-Sequence-Number: 36334 Hi all, i'm planning to realize the following scenario. I have a Xen VM with Sles 10 and Postgresql 8.3 and would likje to upgrade to Sles 11 and Postgres 9. This step i don't think it will be a problem. But know i would like to make this VM high available. 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. I read something about DRBD, Wal-Files, 2x rsync, Slony, PGPool 2. I saw that other tools also works. But it's unclear what the best solution is for a HA System with 2 VMs, which are running on different servers. If the first server crashs the other server can run the secondary instance. Both servers should indenpendent run. My first meaning was from this articles which i read, that i should use PGPool 2 in combination with DRBD and Heartbeat, but without practical relevance. Who did you realize your HA System? What solution would you prefer in my situation? best regards Benjamin