[pgpool-general: 8347] is possible pgpool-II 4.3.x with only 2 nodes and VIP address?
Michal Jerabek
jerabkin at post.cz
Mon Jul 25 18:23:41 JST 2022
Hello,
should someone confirm me, if is possible to setup configuration with
pgpool-II 4.3.x , pgsql 14.x with just 2 nodes and VIP address?
Each node will have a pgpool-II role, and pgsql 14.x role. I have experience
with 2 nodes setting with pgpool-II 3.x and psql 11/10/9.
When I trying to set it up, pgpool always relase delagate IP address, when
node B is powered off or service pgpool stopped.
I think for lost of quorum, but i didnt find right setting and parameter to
get it work. Is it possible? I know that 2 nodes solution have some
limition, like split brain in rare case etc.
Thank you for reply and have nice day
- JEM
examples of pgpool-II log
22-07-21 15:17:18: pid 2023084:LOG: new IPC connection received
2022-07-21 15:17:24: pid 2023084:LOG: read from socket failed, remote end
closed the connection
2022-07-21 15:17:24: pid 2023084:LOG: client socket of a.a.b.b:5433 Linux
node-b.local is closed
2022-07-21 15:17:24: pid 2023084:LOG: remote node "a.a.b.b:5433 Linux node-
b.local" is shutting down
2022-07-21 15:17:24: pid 2023084:LOG: removing watchdog node "a.a.b.b:5433
Linux node-b.local" from the standby list
2022-07-21 15:17:24: pid 2023084:LOG: We have lost the quorum
2022-07-21 15:17:24: pid 2023084:LOG: signal_user1_to_parent_with_reason(3)
2022-07-21 15:17:24: pid 2023081:LOG: Pgpool-II parent process received
SIGUSR1
2022-07-21 15:17:24: pid 2023081:LOG: Pgpool-II parent process received
watchdog quorum change signal from watchdog
2022-07-21 15:17:24: pid 2030089:LOG: watchdog: de-escalation started
2022-07-21 15:17:24: pid 2023084:LOG: new IPC connection received
2022-07-21 15:17:24: pid 2030089:LOG: successfully released the delegate
IP:"x.x.x.x"
2022-07-21 15:17:24: pid 2030089:DETAIL: 'if_down_cmd' returned with
success
2022-07-21 15:17:24: pid 2023084:LOG: watchdog de-escalation process with
pid: 2030089 exit with SUCCESS.
2022-07-21 15:17:25: pid 2023081:LOG: child process with pid: 2028676 exits
with sta
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20220725/1acd3af3/attachment.htm>
More information about the pgpool-general
mailing list