Hot standby off of hot standby?

Started by Igor Schteinalmost 14 years ago3 messages
#1Igor Schtein
ischtein@gmail.com

Hi,

Is it possible to use a standby instance as a master/primary for another
standby in Postgres 9.0? In other words, does PG 9.0 supports cascading
standby configuration?

Thanks,
Igor

#2Simon Riggs
simon@2ndQuadrant.com
In reply to: Igor Schtein (#1)
Re: Hot standby off of hot standby?

On Mon, Jan 30, 2012 at 4:36 AM, Igor Schtein <ischtein@gmail.com> wrote:

Is it possible to use a standby instance as a master/primary for another
standby in Postgres 9.0?  In other words, does PG 9.0 supports cascading
standby configuration?

No, but 9.2 will support that feature, known as cascading replication.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

#3Josh Berkus
josh@agliodbs.com
In reply to: Igor Schtein (#1)
Re: Hot standby off of hot standby?

On 1/29/12 8:36 PM, Igor Schtein wrote:

Hi,

Is it possible to use a standby instance as a master/primary for another
standby in Postgres 9.0? In other words, does PG 9.0 supports cascading
standby configuration?

No, that's a 9.2 feature in development.

If you can build PostgreSQL from source and apply patches, we could use
your help testing it!

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com