High Availability: Hot Standby vs. Warm Standby

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: High Availability: Hot Standby vs. Warm Standby
Date: 2010-07-09 11:51:03
Message-ID: i172f8$kug$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

we are contemplating the possibilities for a Postgres HA installation.

As the rollout is targeted towards the end of the year, 9.0 and it's new features might be an option for us.

Now from a HA point of view, what is the major difference between 9.0's Hot Standby and 8.x's Warm Standby?

I am aware that I can use the 9.0 standby server for read only queries, but that is (currently) not something we need

I'm wondering about the differences when the failover situation occurs. From reading the docs, I get the impression that 9.0's streaming replication might be faster than 8.4's WAL shipping, but otherwise offers the same level of data protection.

Is there a difference in how much data could potentially be lost in case of a failover?
E.g. because 9.0 replicates the changes quicker than 8.4?

If there is no (big) difference in reliability (or potential data loss) I would rather go for 8.4 than 9.0 just because the feature is so new in 9.0 and might not be 100% reliable at the beginning.

Any input is highly appreciated.

Thanks in advance
Thomas

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andreas Schmidt 2010-07-09 12:26:58 Re: Monitoring PostgreSQL on Windows 2003
Previous Message Gnanakumar 2010-07-09 11:30:45 Postgresql shared_buffer and SHMMAX configuration