Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group