Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e1bAv-0004m7-4K for pgsql-admin@arkaria.postgresql.org; Mon, 09 Oct 2017 16:45:05 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e1bAu-0007j0-NA for pgsql-admin@arkaria.postgresql.org; Mon, 09 Oct 2017 16:45:04 +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 1e1b93-0002DP-Oj for pgsql-admin@postgresql.org; Mon, 09 Oct 2017 16:43:09 +0000 Received: from n3.nabble.com ([162.255.23.22]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e1b90-00048r-Mt for pgsql-admin@postgresql.org; Mon, 09 Oct 2017 16:43:08 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id 5B30C8C67F95 for ; Mon, 9 Oct 2017 09:43:05 -0700 (MST) Date: Mon, 9 Oct 2017 09:43:05 -0700 (MST) From: pinker To: pgsql-admin@postgresql.org Message-ID: <1507567385371-0.post@n3.nabble.com> Subject: Logical Replication MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 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? 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? -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin