Re: HA planning

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: Benjamin Knoth <knoth(at)mpdl(dot)mpg(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: HA planning
Date: 2010-12-17 12:10:22
Message-ID: m27hf8lhw1.fsf@2ndQuadrant.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Benjamin Knoth <knoth(at)mpdl(dot)mpg(dot)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

In response to

  • HA planning at 2010-12-15 14:13:11 from Benjamin Knoth

Browse pgsql-admin by date

  From Date Subject
Next Message Dimitri Fontaine 2010-12-17 12:11:50 Re: Extending PG - The Experiments
Previous Message Syed Khan 2010-12-16 22:08:51 Postgres 8.4.2 "could not receive data from client: Unknown winsock error 10061"