| Lists: | pgsql-generalpgsql-hackers |
|---|
| From: | Igor Schtein <ischtein(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | simon(at)2ndQuadrant(dot)com |
| Subject: | Hot standby off of hot standby? |
| Date: | 2012-01-30 04:36:41 |
| Message-ID: | CAN_fNGD-9_HxGz8SH5aA0Z6yBWDBAeZAoUBrx+rTNZ_Q+jVX4Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general pgsql-hackers |
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
| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Igor Schtein <ischtein(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Hot standby off of hot standby? |
| Date: | 2012-01-30 09:25:53 |
| Message-ID: | CA+U5nMJCjj-rHbh6ckAojZwBW3a08TZjn8WY-s_Ng230tCtonQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general pgsql-hackers |
On Mon, Jan 30, 2012 at 4:36 AM, Igor Schtein <ischtein(at)gmail(dot)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
| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Hot standby off of hot standby? |
| Date: | 2012-01-30 18:06:09 |
| Message-ID: | 4F26DC11.1040107@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general pgsql-hackers |
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