Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wQfvz-001ldl-0v for pgsql-general@arkaria.postgresql.org; Sat, 23 May 2026 06:34:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wQfvu-00FPlI-38 for pgsql-general@arkaria.postgresql.org; Sat, 23 May 2026 06:34:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wQfvu-00FPl9-1t for pgsql-general@lists.postgresql.org; Sat, 23 May 2026 06:34:03 +0000 Received: from mout.gmx.net ([212.227.17.20]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wQfvt-000000010Qd-1gBT for pgsql-general@lists.postgresql.org; Sat, 23 May 2026 06:34:03 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1779518040; x=1780122840; i=shammat@gmx.net; bh=0rSWyVSIsHQkgskIhQRVcyWAywirBpqmWjzogEoseNg=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To: References:From:In-Reply-To:Content-Type: Content-Transfer-Encoding:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=RcE5Y3GCCxpKkX+iyWs82lwHmhjMuOoHDzUb+lZHmV2hHjIIeQ1mSpsfQfDFBXrb uZZkBuq+JBos0ox9QTWPHXapzEwqSQEnjHBjY8UDQybPs5vZ8TzpNqCTQLn8VbqZi m82jnz3pVpe07k8O9vi4YKWJwaEq1AX9vIgY9bgxpnDx4+cDKFWpM8d6Bqwx2g4yt 2ehj9PRZs+o/sup7Sv10UaZqutHXd6RcQ2nIALoOi3kPj6UVjkA8V4Q6q0ID4sJ3J sudoTnb9K/8ej1T55CLML5BXCGUSgFG4SsgSvWYQ9/MVKf2tU5bwSi4JR0AnXkJBq TJV5s9YrL0/Uj93vUA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from client.hidden.invalid by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MA7GM-1wcFSf3Tqs-003evb for ; Sat, 23 May 2026 08:33:59 +0200 Message-ID: Date: Sat, 23 May 2026 08:33:59 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Can logical replication be a solution to my current MariaDB/Galera setup? To: pgsql-general@lists.postgresql.org References: Content-Language: de-DE, en-US From: shammat@gmx.net In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:fX1vDuFwc/LKNpLPfOc2Wre6U8Tk2t1MBUWmFlsuANnFu4tCJ9v 9JaS0RAuR3LgdawSxX3gNLGopDRDoIva4c6AZ27NFXWDbkWmbmRWf96yTEpyxZbpN01sndK 2CKn2VpYFEkEX0dkyc7ziEo0D10kCwimaeurwrO72aVAjfOBoETtimiCyxNV2nkY7qnoQwK ZKr2NyxZ44/Vgsxt8z1yw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:2OkVRaPqY9A=;ZZX03ISu1mJVjiqjbPcaerFZbL9 xAIrpZhmW8sDyJ/Pq9+nxdLmKYk88rsWyLGvmDnd+NslVgz3Cbugd4V7WbP2V16cimUjmLEeb dfzD9LQ6glB5xefC1Y4aJGepUrJAVgL+qFPkgdxYpAbTfmaYOQlmHL/prULbmlEi2wT4KCC2S 3M05dAErEUi1QYMPCIxvSP8x+0pBE1pVwt+1tcsVQRMhMDoof65GeWv5pZlFdO0Ak7xvmM7K1 sjN1eHUB615lQYhI8jBTIMpPBjQnglL9CzZtIA6scELMOIgBm2+SBON1ZhidtHBHQkh62f8hl YdOG1j9FCPHc1tCTJFWbNlW3z6LU4thkVLmXgGllTSIA+amgudZO3Tg2oQoxspyCU/sfxQWek tF7hAMTZUo3LOveiW2NiXKJcV2gMxRdBNEgR0SCgFghdBsdLIm0bfkEKKBS5uh9xUYNttDOwn HxztaffSj7mKfYSPbg1Z/wiXJ2lnVU9GTmEwmWcgYkgQte8dDswfR+Y0wLnEq7wWuX7jxnq7m 7OxMA7F4q3INf7mooybM4OtZwTNxiY8FzFZ14Z0/0RdYyrQ79An2YVD+JFVJIZRE//vJszbPn qFr+vFuWR1GdZc5CmZSs1sydMzDSxEGMz1Fl4Rt4mT/dLaRLSpruosGq+6ZIsdsWfJ6TvFHDl VWUTuuL2TE+wX0ghw91KLGIGNNnpb9+4XdzeqsSKw18Q6A8vP06Cr9Z6X3/nUZcecapY/BaKX ZFWIVLwTDu/MDOf8/gLeqLtlbzrhqIo0K8gmGgiFU0M0ZZlryvHYmIrEtFBSiBi1Bllh5RKFJ FT1u7IcyX+2fe1PeKwi0EOsSHqzf7KfAewlj8P6ZYCnKEZpunGNuclChkUWzdMUAj1z+wHogk ysNCq8WAW8wCljrDFGUB2/rCUr1gH51e7VfLY1fGUUpWZdMrpt8Nd9TPYeJfL5cp+Jn70KxT+ fkflBXJP2L/hVcYcxvaMaESI/BLjBj+4jIcI3bmNv4Wz9uHhJxXB8RT1zyDXlBOjIZ9WyuVzf RqWgKEW1z5FZfslA0ffTioJnSpp4VHipzO4hCGXn8k/lmuoXeiIcHchCihFyS4nK3XK1Hs2Uk OaSc3lyLtgg64qO34QuNsd91J2R17N5rBdaZYYP5f795XzJ/9Ax5eXtQPzCm+M68fPX6Tprwu Syspqztqu8W+IEWa7+O/7vNeI6B+PA5NWQHmSmi7k22PHap7P0yTmvoWw5QMVMKIRt70bN6IA hvrwxZEscXSjjzg0Oa4qn3oE3rayKi9DfQFNAhZ/02XK9pqYZol3qNUfcVxCZi5o4NWOyLxWt 0iQ5Dc7ol7zFzaH6GBNF25F5r60l93JD5UkLeRxp0NowwkhHHNFWBCXK3mbBsETIBkIIOuI2s GPPi3ZFoYyXFIgWFQcQ5eoBFB8wZO4gaOfd6WUpf3/to4i+82ZF1GCrScFPznQHxQ5KnLpp7S Ad6vSBUdZZN8HJD+IUPQ4+vDsqCMO/YNp77HRdQH3qRXX11OmIxkvp+b1n9xl7m/S/c6HgUjZ h6Pyqz/wjnd56L06VL47syHQlbSMmb7We4jqNYSVLhFiu5jIUGg0PJiOTyMEGbHSdeeJMXBvK p9x/sDu4l91CnCrnQVCa6paBq2J4/VbPA0muuIdjI0vcs6L3WSOIH1CL/C5dsQf9b13GZA9SO gFi2B95LcF2wIKU8ClvaPK7ZwfKeGVIRoJTw9e6xTvpisUEk9EPWIbNsqb/PtrPvTRBuB0K0C ZYH1aS92iwXfZUZJWWJfLch5bbt1EiycE6w3mBKky7wTv0I5V5rsVnoE9D1nlGiDgwhy5YJdv 2xdVoJyFWuegF0hfRSxXOFKDMFrjt7UV1BtpvnGy8C2VTymtdAhLmXJYwLdvT/vDb095DkbG1 FypnE+CSoAxaWoRpkHuNSEsLqTG6i57LGTAWgPwfDjyU1KapOLGJj8FWB7JQAydLK4PeD4Okw 4tBv1WDppihiY1ILwTvVvFqAdydGrZm1vBM+6D78DCR6H73jlxzxEjeP6pSx4WWxBwYV4jrhu tmdIATIS5L+NnLzoQhY3a5TqYKpWQRgeJRjfmgfZKYgW/2aRXCH3n/Jf5t9OIYWnsQSq4ZMJo kKnYtcSpJbddKyPOWA2gqj6f6EboBWHK234v24SeHufj6cceSSmW0cQpqjNMRRwC1MGfFccms 9VfDV2rRx0ZBaxpL+uIlNvul4o4nGetfIiR5eVqNk4oCbKE1EMLnjAgY+r0S8+lPJ2RB70wfG GUIDeDLp+HeaeSmUzG1HczWhEfKIrhuLoakUlE0OqsRga4UuVsnyhLnnOzD9JV2Vq1H78Ga00 mOQDenhikwxw8IqG9KhHsp7Fc63zSPIYxD19cuUzx+2Kk55acqhXOwdXZL/Rw0n3pBR7/OxXa 319FFVhAGxe3sqNv74gWZTC6m0P07jpfB9v9BZGv3KBplG1at1R+EK8f1kyquDtMmbxQlciab cRRDK1Ir7jOugChtqa4VHtYrdQC36gcDflGSUFyVxUhKs2ijzC4hGKGT3vPX6oivEQ8sGpOvx C/x0q8U9Hb4nDuRQXEB1z99GHPJo3lycLC1Sfpqhb5qupvxiVVdPq/oBtWe62eVAH1lg6qWxg K3YsNV3r1dGXESFa2XOM5/oWbWcyD0+ipxeOdugvbT/TXiGXcBwjhyWNbmdPT1/EhoRJzLO4f J3oGkDduCTFxFMPqZAWTzYSEYhYF8lsQpcdC9z45cokkbQNMYibjdWxX6Fcf1znIj9zZXYIrS Mfm2SeVxGfq3ERbE6nZww/kMnFAaEJB8lZY1j2vQ2q1GS78uTSXh+qYJf0hZXxvdscONnsgLR 7Y7GDQiq/HcpcxYe+AYyhaGGy0ke0TtiYk54RjHB98V1V1n2/gyV8dsxHagi6USLxdUhX8NPm UyMBc0RICmM0h7jLpAFl6dgWN7u7eMbAWmVPGSQ9sA7Q2OyPCvEFwqU8m/MpD0Jt4SUv3G5Te PM4AyBHvQHNucmbgc6JDQanMMFMXFxqu3Tu/CRcaaVDlcvArwNJWFEqKt7M/9XEum9wd4FCNk nGih1tKK87EDh7knSkNQSXXrAR3UzmjAmrqpu2rLDqlIn+PGlGEYzytjdRlY98YxBz6JvZJaz PVrmXKKhLX2jNvvCLUCrqx+wcc6I++09PAymecOoi5hPiKzswa6UTgGkoGcf5R47AfbG7WNMl EWmTdernSUl5OIASwFFRKyDsaH2LN7Por/h/W1o1OduBPDVy8EWR1UhUdNe6P51bDSyCJn6GR MU8ois6JdR12N4WAW8nIr1gXaF6ToQNcnMjWweOA9mITFLsottx9aO5bArm+Zk+l/aeJJuWZp wX8aUmtcZqA1P2JgQg+ASKS72jcWI1dsDt0iBjGmi62ynBP+rzAQ0HcO9hRuDHEhHLi2pPcVw w0J8MNeSWwzTTIqtFVsbOmeJ/g+0n3guytxysulD9rEjkIF5Efn6Q/gmrlCQgvhGe/LUZOgv4 XsYzdSpMN2B1RZXLp2pAQFPuRe+Rid4DGTV+CUkvljZSgJgxo1BBT/aBwdO9mUtNBnX6npF8y A5TwyVbQbODqb4FNtQ7bPT85xc7wkO710cyvxThsCZ6HfX8j/wipBUh1xERLEHAxie8zRT8jf wcdfytL4GSH5eMhtTsMlFH9FhHcCt3VuDjfGBeIfryUq4xakjKH2Mb9vSGVppNxej7Yifz9uJ MhNn5Vg0isu25OIhcv37xAB6UNqI5qIgO6HI8a7cZKpImQcD9KhSDecKKIxDBSB+0mSAsXDGv GrjQexEFjbsdrcYkA/q7016zEUVTPSl9reW6AuWFLvQFGkoFOmYFJNLIu6EeE7GgRQLkkPT7K vwAhtvVprZyIuRc6eXTTczvi9vupwJA50PAgAxOveW5KIcnrUuC7UmogON6uB4H1DMCScPrXM E6Tb4U4DUJAgYtcXwLby8MyCGmd5U+fMES9ljFKsNJ4z9osQo3J1b9Ptp8LzfeRN579iI1oVg GzRCFdtkucJRIQ4/KtZw1GuRzLbwdkeaUignwMI53fxoJYJcqnvH8lc1ddNIqCCaQeY+gO/kY Sqhb/jmfl2mQ4ImNfz9cFJqAewdHa2KiWYWHVn0GISeNnDriywnIowhqy9LydsmNWrvUxtDJy WK8NhDlgHhJzrJzk18QVkjARfdeebD1D1glgK3QmzEuinpoVdmARbVxiHfhR9B/6G4KVax0hx DGI6STiWAduLjEtZe3STo2O/1iZyXyfD8yqPnxjt+p+SQ+1qgLoSsriwCyR9bf6fkVBSsFQIG uaqkQxL6wBEo7bvSKE7rysvl6A7I0TFcG07VTNn06REtVQAYA+ftJR0yoUoEHeY4aa5SxJv0I lhimTfOk/fQQx4EdfUCbMOdI+Nvq4giYH1JTKiapCwQxglYiLBlevm3QwtF7ew/U1OS6jnlLP /MxKlVGkhuEvKA5b3JjLPkyCb+diLLUuJqHhrDLOEvALQCgpZHHH1VHdl+BqNn4AXBeBB2+xI oDdcxlvbqGKKc1H1A+YYb84I+53rU+he2YifyDBhl7QQuISX3K/BWFXOTNj6uVbqGEnlQ8qTE jv6o+AIWZaEGl7LoO+ShGe4Yp4xL9d4R8GyXaUcEZWcYAU3GwOzZlog3wElKCRPrd8yCF9eVk QJmCC3GYyG+XhbjvMmrjKuY04EyjgTdjk8UDcPSjVUPXe6gZUAgJrds4gnLTT26nvZmAy1WjQ k1hydmf5hWldB1/EO44HrP1OjM/ETP04HZX6Gq1I9Q7FpgKJrtCCDKq79OEKR35Mjlkyc3WIF YHnEnz17Ld1VpXEEj7x/PIOhMOp6KWBoEwVSlzMZwcjWqJaEiBcXnZ+ce8dPIy/CtaexhWa2/ oOrnwEmSCw60B7ofsc6+7xDRJq0/CdmmOv6FlfEzeglBFNbcb6q4kGKf0RNaSGNuPhOkauKr6 /zSAzs0Kk/l56h3Pt02NJG3RuaSumzR8qPDx4W2yYwxVMH0zaM/QnzKdtwm8K7uzg1rS2DQFx B7kSlYqlgXU0Pl3IvQ/QOPwTkyuJ+qxfy6ZQcYIIsd+871fF++bDYeuHKaWktTbMguo9Ihfrh P1XZiujisJ/P4DO85izF/GXqeeNIg10Zko58SXBpy5fe+5PdsNyzKojzO9v1vAT9lqDKrNu/j trTcd9kmvnNHhcaSPMdKMf/PS1BRVu8nTfDENX23uUH5kSn2PuPs73GAJdFeucYQ2+Qd8bLQp AKCSEgfxFtlgaUxQS8Z3b9W8j0DkTbiXmCghGImF2WaPjd4Wzk66RV+LMpCh69nuBtaaiM8+G S6C9lmazWOw79ljFDfV0ogzLzmAeOre2HOO93dHT6fJYTXw2b9x/J9Pd0uPxcAmFsOQA9MHB0 tguJ0vQ9Ab1gzdtw33x8nnAL1EsG1ljmA5ZodtEFJZm16p6ZhsjCoNX7QtZn1gZiQqOhZPP9X bwSIX4pNy3Hewmwfkrl0aYmBytkZ/tdGjn//ramckQ9gY= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am 22.05.26 um 15:18 schrieb Michael Grimm: > 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 ;-) >=20 > 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. >=20 > 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? >=20 > Here are my questions: >=20 > #) Is this feasible or nonsense? > #) What would an alternatives for FreeBSD be (pgpool-II, repmgr, =E2=80= =A6)? For such a system I don't see the need for a multi-master setup (neither with Postgres nor with MariaDB). That's typically used if you need to spread the write load across nodes, quite frequently because access is geographically distributed and the latency is not acceptable. For high availability you don't need multi-master. A standard streaming replication with a failover mechanism is completely enough in my opinion.