Re: HA planning

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