[pgpool-general: 8664] One node always primary

[Jesús Campoy]

Hi all,

I would like to know if there is a mechanism to ensure one node is always
primary.
I have seen the ALWAYS_PRIMARY flag in the config file but I couldn't make
it work.
I tried to put in the backend_flag the value
"ALLOW_TO_FAILOVER|ALWAYS_PRIMARY" with no success.

I have two nodes with streaming replication (server1 and server2). Server1
is primary but sometimes I have to power off it and the server2 will be the
new master because of the failover. What I need is to make the server1 the
new master when it is powered on again.

I appreciate any help you can provide.
Thanks in advance.

Best,
Jesús
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230322/b81ab80e/attachment.htm>