From: Benjamin Knoth <knoth@mpdl.mpg.de>
To: pgsql-admin@postgresql.org
Subject: HA planning
Date: Wed, 15 Dec 2010 15:13:11 +0100
Message-ID: <4D08CCF7.1090104@mpdl.mpg.de> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: knoth@mpdl.mpg.de
Subject: Re: HA planning
In-Reply-To: <4D08CCF7.1090104@mpdl.mpg.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox