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

[Lazaro Garcia]

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 <mailto:AviW at gilat.com> >
Cc: pgpool-general at pgpool.net <mailto: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>
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. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170601/db50f9f9/attachment.html>