| From: | Michael Grimm <trashcan(at)ellael(dot)org> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Can logical replication be a solution to my current MariaDB/Galera setup? |
| Date: | 2026-05-22 13:18:35 |
| Message-ID: | F549C6B0-0A6A-45F1-88AD-B65BC6403A32@ellael.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
this is my first post to this mailing list, and I hope that I chose the correct mailing list.
I have never run a postgres server before, but I do run a mariadb galera cluster [1] for storing emails by an IMAP server [2]. Distribution and failover is dealt by haproxy [3]. This mail server setup has to deal with less than 250 mails a day, a database size of under 6 GB, and a handful of users. You see, that this system is bored to death ;-)
I have read a lot about replication in order to find something comparable to a galera cluster with its multi master capabilities. Now, I have learned that multi master can only be achieved by using third party plugins. Not all of those are available for my FreeBSD systems, though.
As a newbie I do currently tend to use logical replication with mutual publish and subscribe instead, either by pglogical2 or "self-made". I am in the -probably naive- impression that this could work. As before, failover will be handled by haproxy by simply directing read/write access to another postgres node available. When a failed node will become online again, logical replication should enable this node to recover, right?
Here are my questions:
#) Is this feasible or nonsense?
#) What would an alternatives for FreeBSD be (pgpool-II, repmgr, …)?
Any input is highly appreciated.
Thanks in advance and regards,
Michael
[1] 3 nodes, primary-primary replication.
[2] https://dbmail.org/en/
[3] All incoming MUA requests are directed to a single node in order to prevent split brain situations
| From | Date | Subject | |
|---|---|---|---|
| Next Message | shammat | 2026-05-23 06:33:59 | Re: Can logical replication be a solution to my current MariaDB/Galera setup? |
| Previous Message | Adrian Klaver | 2026-05-20 14:48:10 | Re: Large backup size of pg_dump |