Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mq0BK-0006xi-QP for pgsql-admin@arkaria.postgresql.org; Wed, 24 Nov 2021 21:51:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mq0BI-0006T7-KU for pgsql-admin@arkaria.postgresql.org; Wed, 24 Nov 2021 21:51:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mq0BI-0006Sx-7x for pgsql-admin@lists.postgresql.org; Wed, 24 Nov 2021 21:51:56 +0000 Received: from mail-qk1-x736.google.com ([2607:f8b0:4864:20::736]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mq0BC-0003bf-HP for pgsql-admin@lists.postgresql.org; Wed, 24 Nov 2021 21:51:54 +0000 Received: by mail-qk1-x736.google.com with SMTP id 132so5316043qkj.11 for ; Wed, 24 Nov 2021 13:51:50 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=message-id:date:mime-version:user-agent:subject:content-language:to :references:from:in-reply-to; bh=sG1WhJ15PXeDwr6yA0D9ADlhg23sx6HawwTruAXnCpU=; b=JozoFtUFm30l/rEqF1OX3z83S+R76BpdOre4V2KLz5N++XEjmlyxuTFu63JMcOfwKk IN5vXlQCwYgZP5IdmlMcbeH7aALow3BpRf/N62GVNu3Gq4ufvmFfmmilNvhCO+mlZ6DE GwgAx0kqM5taPDNYSWq9S8nCVF2JHUIDPARSy+1op6kc/vtH1xFR6pdtq8+bMTiF0C1s 4s/qKNxSP0Fvpb+uy6NE8+v0XHtS/U2mFt5Hhf0vWWFjaDSwZ5+xh0XbFZjkm2dlF6rX 9gSCx15My/4fKJX0fsgHyzD0lM7/i+I2teOQ8e1hI79c+9snUZwc2//osB2IGCeqJMZI AKsQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:date:mime-version:user-agent:subject :content-language:to:references:from:in-reply-to; bh=sG1WhJ15PXeDwr6yA0D9ADlhg23sx6HawwTruAXnCpU=; b=d2NXmM+eKZ+yoQURRy2qwMIBmXDksfYQRDkNeoK6g0t7TdVhSIbnRsYsjfW/R4uGGk 51FO/lryMwhjkpATmr+2KHSR3xdePCvy/exyOJI8kOEvqfNLwOZeYoPxcptsSImngxcU KMFAW82QF9XhkaQ71WFIG4WXUemWkArKt2rw9jh5SZiHoX/ah2RLp2y52Y2NjTU/0+ii qJ5hmj0Z75zQElqPDxrbyf8oxsNsIK+JscLDU7ApwETrIQULAfg+zj+QDhmOP+7zPvDo x+sW6OSABxRjJlqJeNvSCiupU0Fa+YfqNvudB8HlHdR5dn4ED9VnEBl8yrIBP7g6Dc+0 iQqg== X-Gm-Message-State: AOAM532uWFQ2ALf73ruxz29n0oBheaKJHT4h4d2d5oGssMBbp8kHdU4y Jtmsl4nGu9IADd4oBoSUUukRsbb4fwMv6g== X-Google-Smtp-Source: ABdhPJxvnXTLQQ3lqMXYcpfhkw/wsh/fEsofDfF1GojMF6b7z79sSaFlV4+iPgZmykc1ZGKZy8He4w== X-Received: by 2002:a37:88c6:: with SMTP id k189mr1768031qkd.683.1637790707560; Wed, 24 Nov 2021 13:51:47 -0800 (PST) Received: from [192.168.2.100] (pool-72-79-19-93.nwrknj.east.verizon.net. [72.79.19.93]) by smtp.gmail.com with ESMTPSA id 73sm434773qkm.94.2021.11.24.13.51.46 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 24 Nov 2021 13:51:46 -0800 (PST) Content-Type: multipart/alternative; boundary="------------Q0ZvgbCruTzFyRGXMpMWIsJ0" Message-ID: <4a64b049-2534-37aa-07b1-5c29d3dcada9@gmail.com> Date: Wed, 24 Nov 2021 16:51:46 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.3.0 Subject: Re: Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: <6cb32d43-75d1-b896-5267-48d75c536808@sqlexec.com> <0ED6B91F-C228-404F-A4F2-B9532E205B2D@jakobs.com> From: Mladen Gogala In-Reply-To: <0ED6B91F-C228-404F-A4F2-B9532E205B2D@jakobs.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------Q0ZvgbCruTzFyRGXMpMWIsJ0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 11/24/21 12:08, Holger Jakobs wrote: > Are you aware that the original poster asked for open source solutions? > > Of course, BDR3 is a great tool. ** Postgres-XL is not exactly a replication solution but it is ACID compliant and it doesn't have problem with sequences. It is a decent high availability solution. More information is available here: https://www.postgres-xl.org/ -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com --------------Q0ZvgbCruTzFyRGXMpMWIsJ0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Re:
On 11/24/21 12:08, Holger Jakobs wrote:
Are you aware that the original poster asked for open source solutions?

Of course, BDR3 is a great tool.


Postgres-XL is not exactly a replication solution but it is ACID compliant and it doesn't have problem with sequences. It is a decent high availability solution. More information is available here: https://www.postgres-xl.org/

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
--------------Q0ZvgbCruTzFyRGXMpMWIsJ0--