[pgpool-general: 5377] Re: [pgpool] Streaming Replication - Identify Slave Node Status

[Anushka Weerakkodyge]

Thank you! I will try this method definitely. By the way, what I really
need is to fail the transaction when slave is down. Using this method I can
identify the status of the slave node, then will try to make the master
node read only until the slave comes online.


Thanks,
Anushka

On Thu, Mar 16, 2017 at 6:36 PM, Lazaro Garcia <lazaro3487 at gmail.com> wrote:

> When slave goes down, pgpool detects that and triggers a failover, then
> the master remains active and the slave are marked as down state. On the
> failover_command of pgpool, you could execute a command that drop the slave
> from the master synchronous_standby_names and reload the configuration on
> the master. By this way new transactions can be executed on the master
> without checking the state of the slave because synchronous replication has
> been disabled.
>
>
>
> If you recover the slave you can attach this server to master again an
> activate the synchronous replication.
>
>
>
> Regards.
>
>
>
>
>
> *De:* pgpool-general-bounces at pgpool.net [mailto:pgpool-general-
> bounces at pgpool.net] *En nombre de *Anushka Weerakkodyge
> *Enviado el:* miércoles, 15 de marzo de 2017 05:37 p. m.
> *Para:* pgpool-general at pgpool.net
> *Asunto:* [pgpool-general: 5370] [pgpool] Streaming Replication -
> Identify Slave Node Status
>
>
>
> Hi all,
>
>
>
> I have a synchronous streaming replication environment which is
> implemented using inbuilt replication mechanism in postgresql. There is a
> requirement that I need to fail the data modification transactions on
> master node if the slave node is down. (ie: transactions should commit when
> only both servers are up and running)
>
>
>
> Please let me know whether there is a way to identify slave node status
> and fail the transaction using pgpool ?
>
>
>
> Thanks,
>
> Anushka
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170317/985c26f9/attachment-0001.html>