[pgpool-general: 8334] repmgr and pgpool-II: is wiki correct suggesting not to use it?
Alessandro Dentella
sandro.dentella at gmail.com
Wed Jul 13 07:55:56 JST 2022
Hi,
I'm just diving into pgpool for the first time.
I read in the wiki (*Can I use repmgr with Pgpool-II?)*
that you'd better avoid using repmgr and pgpool together and points to a
document where repmgrd is used to monitor and failover.
I have seen other blogs (
https://jensd.be/591/linux/setup-a-redundant-postgresql-database-with-repmgr-and-pgpool
)
where rempgr is configured with failover=manual and repmgr (the command ,
not the daemon) is used in the scripts
pointed to by 'recovery_1st_stage_command' and 'failover_command'.
It seems to me a solution that allows a clean way to setup replication
(repmgr is IMHO pretty straightforward) and the power of
pgpool in load balancing and detecting a server to evict.
Am I wrong when thinking that the wiki advises against one setup but does
not consider the other possibility?
Any hint is appreciated
Sandro
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20220713/09184cb5/attachment.htm>
More information about the pgpool-general
mailing list