[Pgpool-general] Pgpool, Streaming replication and multiple slaves

[Alessio Gennari]

Ok for parameters, but in my tries the major ploblem is the change of master
in recovery.conf file without restarting each slave.

When master fail, first slave become master automatically, but the master
was mater for each slave, so recovery.conf is not modified in all other
nodes stream replication will fail and only one node will remain online.

Is there a manner to change recovery.conf?

Thanks

Meph

On 16 May 2011 13:02, Sandeep Thakkar <sandeeptt at yahoo.com> wrote:

> You can have several slaves and one master, though I have not tried it yet.
> You need to check "backend_hostname, backend_port, backend_weight"
> parameters in pgpool.conf for this.
>
> ------------------------------
> *From:* Alessio Gennari <gennaria at email.it>
> *To:* pgpool-general at pgfoundry.org
> *Sent:* Fri, May 6, 2011 3:15:59 PM
> *Subject:* [Pgpool-general] Pgpool, Streaming replication and multiple
> slaves
>
> Hello to everyone,
> I am planning to use PostgreSql as HA backend system, and I am very
> interested to pgpool-II: I have installed it and I have performed several
> tries to test features.
>
> I would use pgpool-II to manage some Postgres databases in streaming
> replication. I need to know if is possible use one postgres master and
> several slaves in streaming replication coupled with pgpool-II. If it is
> possible, are there some configuration example or can you help me to
> configure my system?
>
> Thanks in advance.
>
> Mephysto
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110516/7ed87ded/attachment.html>