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 1kx8zh-0004ro-LY for pgsql-admin@arkaria.postgresql.org; Wed, 06 Jan 2021 13:36:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kx8zg-0005qS-Ia for pgsql-admin@arkaria.postgresql.org; Wed, 06 Jan 2021 13:36: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 1kx8zg-0005qL-B2 for pgsql-admin@lists.postgresql.org; Wed, 06 Jan 2021 13:36:56 +0000 Received: from mail-ed1-f45.google.com ([209.85.208.45]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kx8zd-0003zj-4d for pgsql-admin@lists.postgresql.org; Wed, 06 Jan 2021 13:36:55 +0000 Received: by mail-ed1-f45.google.com with SMTP id b73so4322259edf.13 for ; Wed, 06 Jan 2021 05:36:53 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:date:from:to:cc:subject:references :mime-version:content-disposition:content-transfer-encoding :in-reply-to:user-agent; bh=MiIJey8h0P2DVpuvn8e0rIRUVYbsLd3tzEJDljcbMrk=; b=SgxutZTUzezF7QWJb6Avt1mlzZrlN0tRuVURtO0z+ngMo7bezY9QgwvzIEy9k34B5g kOnZHTkRbhRuT2sI6ipsKpPUDxBondohXHBPh9d5ohvYv4KuNOL0pqURmag8cArPBHS7 GFWr7rsQfRaIK0uNZqGoKg0UCglbWy3a9jBuC15/D345LvDx7uUsMxwC4YJh2Oga5qnI EnDhgFNae84NCJAT/kkWza7Nfa/3GulYeCM2U/JHN5Mbjlzr6mxvRZTd4fkQui6rL2yq xjNng5F6wY8X3Auz8z9EhcXY/oeW2vtPXa/Wl/fibKDl+Yq/2qx7TooZL7si9LYVOE9v 4CFg== X-Gm-Message-State: AOAM530reRmj4eg3qu4VoEgOLWLAxP/mUMqi5LErsNR1DRejBrp3DhyZ L7I20pQyqcNq0GuriHBrMSk= X-Google-Smtp-Source: ABdhPJxVwvR78lK2tRgqGryUPkW0sEKqSFE8xw17b3oC7ETTptXRsiafpy/QzpKkeu6T9EONlorFPw== X-Received: by 2002:a50:c209:: with SMTP id n9mr3963712edf.123.1609940212019; Wed, 06 Jan 2021 05:36:52 -0800 (PST) Received: from lightning.caipicrew.dd-dns.de ([2001:a61:3b4c:4d01:6e18:c24f:2260:4244]) by smtp.gmail.com with ESMTPSA id x20sm1265174ejv.66.2021.01.06.05.36.51 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 06 Jan 2021 05:36:51 -0800 (PST) Message-ID: <5ff5bcf3.1c69fb81.b3a00.3749@mx.google.com> X-Google-Original-Message-ID: <20210106133650.GK13111@caipicrew.dd-dns.de;lightning.caipicrew.dd-dns.de> Received: from mbanck by lightning.caipicrew.dd-dns.de with local (Exim 4.92) (envelope-from ) id 1kx8za-0004uL-CF; Wed, 06 Jan 2021 14:36:50 +0100 Date: Wed, 6 Jan 2021 14:36:50 +0100 From: Michael Banck To: Yambu Cc: Atul Kumar , Pgsql-admin Subject: Re: master and slave at same time References: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Wed, Jan 06, 2021 at 03:31:32PM +0200, Yambu wrote: > If i use logical replication , can i not make it work? Well yes, you can write to the subscriber if you use logical replication. However, there are severe drawbacks in this, e.g. you will have to resolve conflicts yourself, DDL isn't possible unless you do it manually, sequences are not replicated etc. pp. Logical replication for itself is not a general HA tool for Postgres right now but if implemented carefully can be used for some use cases like merging several databases into a data warehouse or carefully only changing data locally. Michael -- Michael Banck Projektleiter / Senior Berater Tel.: +49 2166 9901-171 Fax: +49 2166 9901-100 Email: michael.banck@credativ.de credativ GmbH, HRB Mönchengladbach 12080 USt-ID-Nummer: DE204566209 Trompeterallee 108, 41189 Mönchengladbach Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer Unser Umgang mit personenbezogenen Daten unterliegt folgenden Bestimmungen: https://www.credativ.de/datenschutz