[pgpool-general: 5554] Re: Server to never assume the role of master

Pierre Timmermans ptim007 at yahoo.com
Fri Jun 2 03:56:44 JST 2017


Thank you, it works like you said.In pgpool.conf I have set follow_master_command = ''failover_command = ''failback_command = ''(streaming replication mode is enabled)If a failover occurs then pgpool indeed detect the new master. The old master is detached so when it is restored as a slave one has to re-attach it with pcp_attach_nodeThanks + Regards,
Pierre


On Thursday, June 1, 2017, 6:22:13 PM GMT+2, Lazaro Garcia <lazaro3487 at gmail.com> wrote:


When the master fails, repmgr promotes new master and then pgpool can detect the new master.

  

Regards.

  

De: Pierre Timmermans [mailto:ptim007 at yahoo.com] 
Enviado el: jueves, 1 de junio de 2017 11:49 a. m.
Para: Lazaro Garcia; 'Avi Weinberg'; pgpool-general at pgpool.net
Asunto: Re: [pgpool-general: 5550] Re: Server to never assume the role of master

  

Avi,

  

It is true that pgpool will not execute the follow master script on your slave if it is unknown of pgppol but on the other hand, in the failover script you can do what you want. In your case you could ssh to your permanent slave (which is not known to pgpool) and execute the postgres command to follow the new master.

  

Lazara,

  

Is it possible to use pgpool for load balancing and repmgrd for automatic failover ? I could not understand how to make this work. Is it enough to leave the pgpool configurations for failover script and follow_master script empty ? Is pgpool going to automatically detect that there is a new master and restart the child processes ?

  

  

Pierre

  

  

  

On Thursday, June 1, 2017, 3:29:50 PM GMT+2, Lazaro Garcia <lazaro3487 at gmail.com> wrote:

  

  

For that you can use repmgr for controlling the replica, promoting new master, and follow the slaves to new master and pgpool for load balancing, and HA of the cluster.

 

Regards.

 

De: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] En nombre de Avi Weinberg
Enviado el: jueves, 1 de junio de 2017 09:09 a. m.
Para: pgpool-general at pgpool.net
Asunto: [pgpool-general: 5548] Re: Server to never assume the role of master

 

Hi,

 

Thanks for the quick reply!  

 

I think it will not be that simple in my case since I want the "permanent slave" server to point to the new master when there is a failover.  In case of a failover I want the "permanent slave" to be notified even if the other "non-permanent" slave is dead

I doubt it can achieved without pgpool knowing about the permanent slave?  

 

Thanks

Avi

 

From: PVY [mailto:balroga3 at yandex.ru] 
Sent: Thursday, June 01, 2017 2:45 PM
To: Avi Weinberg <AviW at gilat.com>
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 5546] Server to never assume the role of master

 

Hello, Avi.

As far as I understand, if replication is configured on postgresql side, not via pgpool, then you can simply do not add this particular slave server to pgpool.conf.
In this case pgpool would not know about this slave and it will never promote it or send queries to it.

|  | 
Hi all,

I would like to have a master with two slaves setup.  However, I want one of the servers to always be slave and never assume the role of master.  Even more so, I would pgpool not to direct any queries to this "permanent slave" server.
How do I configure pgpool / postgres to achieve this

Thanks
Avi
IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person. 
 |






-- 
Best regards,
PVY                          mailto:balroga3 at yandex.ru

IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person. 

_______________________________________________
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/20170601/f7432f3a/attachment.html>


More information about the pgpool-general mailing list