pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
HA planning 2+ messages / 2 participants [nested] [flat]
* HA planning @ 2010-12-15 14:13 Benjamin Knoth <knoth@mpdl.mpg.de> 2010-12-17 12:10 ` Re: HA planning Dimitri Fontaine <dimitri@2ndQuadrant.fr> 0 siblings, 1 reply; 2+ messages in thread From: Benjamin Knoth @ 2010-12-15 14:13 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: HA planning 2010-12-15 14:13 HA planning Benjamin Knoth <knoth@mpdl.mpg.de> @ 2010-12-17 12:10 ` Dimitri Fontaine <dimitri@2ndQuadrant.fr> 0 siblings, 0 replies; 2+ messages in thread From: Dimitri Fontaine @ 2010-12-17 12:10 UTC (permalink / raw) To: Benjamin Knoth <knoth@mpdl.mpg.de>; +Cc: pgsql-admin Benjamin Knoth <knoth@mpdl.mpg.de> 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-12-17 12:10 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2010-12-15 14:13 HA planning Benjamin Knoth <knoth@mpdl.mpg.de> 2010-12-17 12:10 ` Dimitri Fontaine <dimitri@2ndQuadrant.fr>
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