[pgpool-general: 4736] Re: When is it safe to attach node

Lucas Luengas lucasluengas at gmail.com
Sat Jun 25 00:35:58 JST 2016

Hello Avi.

I check standby node is up, with postgresql service running, and configured
as slave server. I check "select * from pg_stat_replication".


On Fri, Jun 24, 2016 at 6:33 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:

> Assuming that you are attaching standby node.
> > When is it safe to attach a detached node? What do I need to check
> before attaching a node (I have one master one slave setup)?
> In summary, the detaching PostgreSQL standby should be running
> normally.
> First of all, you need to make sure that the detaching PostgreSQL
> standby node is up and running.
> Next you need to make sure that the standby node properly connects to
> the primary PostgreSQL server. You can check it by looking at
> pg_stat_replication view for example.
> > *         Do I need to make sure replication lag is 0? If I attach a
> slave when replication lag is not 0 what problems can arise (if any)
> If the standby proper connects to the primary, even if replication lag
> is not 0, it is expected that it wil eventually become 0.
> The risk with replication lag is that SELECT might return outdated
> data but you could mitigate the problem by using delay_threshold
> parameter.
> > *         Before I attach a node do I need to check the state of the
> other node?
> No.
> > *         What other checks to I need to do before attaching a node?
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160624/6818075c/attachment-0001.html>

More information about the pgpool-general mailing list