Re: Daisy chaining replication slaves ?

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Rob Cowell *EXTERN*" <Rob(dot)Cowell(at)transversal(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Daisy chaining replication slaves ?
Date: 2012-06-14 07:37:28
Message-ID: D960CB61B694CF459DCFB4B0128514C20800B933@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rob Cowell wrote:
> I'm just wondering if there is a way to slave from a slave server?
>
> I have a Postgres9.1.3 master serving up data quite happily to the web
applications, and I have also
> set up a slave via streaming replication.
>
> I've now been asked by my manager to set up a secondary slave, slaving
off the first slave

That is not possible in 9.1.
In 9.2 there will be such a feature:

http://www.postgresql.org/docs/devel/static/warm-standby.html#CASCADING-
REPLICATION

You can try it with the beta version, that will also benefit
development.

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hamann.w 2012-06-14 08:17:18 Backslashitis
Previous Message Albe Laurenz 2012-06-14 07:33:07 Re: How to create c language in postgresql database. Thanks.