Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e1hRc-0000PQ-NV for pgsql-admin@arkaria.postgresql.org; Mon, 09 Oct 2017 23:26:45 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e1hRc-0004GQ-4C for pgsql-admin@arkaria.postgresql.org; Mon, 09 Oct 2017 23:26:44 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1e1hRb-0004BY-4V for pgsql-admin@postgresql.org; Mon, 09 Oct 2017 23:26:43 +0000 Received: from cat-porwal-prod-mail1.catalyst.net.nz ([2404:130:4080::4]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1e1hRX-0004IH-29 for pgsql-admin@postgresql.org; Mon, 09 Oct 2017 23:26:41 +0000 Received: from localhost (localhost [127.0.0.1]) by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTP id A154C809AA for ; Tue, 10 Oct 2017 12:26:33 +1300 (NZDT) X-Virus-Scanned: Debian amavisd-new at cat-porwal-prod-mail1.servers.catalyst.net.nz Received: from cat-porwal-prod-mail1.catalyst.net.nz ([127.0.0.1]) by localhost (cat-porwal-prod-mail1.servers.catalyst.net.nz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id PvOm7Kc-tQgr for ; Tue, 10 Oct 2017 12:26:32 +1300 (NZDT) Received: from [IPv6:2406:e001:9e1:1:9465:e76c:3af6:820f] (unknown [IPv6:2406:e001:9e1:1:9465:e76c:3af6:820f]) (Authenticated sender: mark.kirkwood@catalyst.net.nz) by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTPSA id 7BC938012A for ; Tue, 10 Oct 2017 12:26:32 +1300 (NZDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=catalyst.net.nz; s=catalyst; t=1507591592; bh=rJ0I9/YbC7kyCPKQd8/LOdIUAOleFcFIHPkztKpaBis=; h=Subject:To:References:From:Date:In-Reply-To; b=FK9Od3s5nwOU207Y2+yo92MPKP8MVaKev3fMqmQdG7vVx+Y/eUBbMsC0EV/i8elMg RQ4ntFerC3FuGZapNxpl5ytkSXz7TPDYrkASsl3pfrjZWpHKRiaYLZEm6oWjIa1jB5 D9pJkFe/s53R90+Nlsi3VgkwhjYGtVBo19iIaXsY= Subject: Re: Logical Replication To: pgsql-admin@postgresql.org References: <1507567385371-0.post@n3.nabble.com> From: Mark Kirkwood Message-ID: Date: Tue, 10 Oct 2017 12:26:32 +1300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.3.0 MIME-Version: 1.0 In-Reply-To: <1507567385371-0.post@n3.nabble.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On 10/10/17 05:43, pinker wrote: > Hi, > I'm just trying out new feature - logical replication. It works great > between 10 and 10, but I would like to try between different major version. > Documentation says it's possible : /Replicating between different major > versions of PostgreSQL/, but I cannot find any post with setup examples > (yes, I did google search :). > Do you know maybe where can I find it? > If I would like to replicate 9.4 to 10 it means I need to install pglogical? > or it's happening through fdw for instance? I think the docs mean that logical replication works between different versions of Postgres - provided they both have the logical replication code! So you will be able to run it between version 10 and 11 for instance. With respect to 9.4 - you probably need to discuss using pglogical with the EDB guys (ISTM that it is slightly different from the logical replication code in version 10). > > Another thing that puzzles me: > I have created 2 identical publications what resulted in the data > duplication. Is it intended to work this way? or maybe some checks will > appear later on? > > Probably worth raising this as a bug. regards Mark -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin