Thread: Hot standby off of hot standby?

Hot standby off of hot standby?

From
Igor Schtein
Date:
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 

Re: Hot standby off of hot standby?

From
Josh Berkus
Date:
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