From: John Scalia <jayknowsunix@gmail.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Logical replication issue, pg 13.9
Date: Thu, 30 Nov 2023 09:59:59 -0500
Message-ID: <8BBAD76C-AA63-4B2E-ADE4-3835B373E470@gmail.com> (raw)
I’ve got one instance with a couple of databases on it, that my developer wants one table replicated from one db to another. I manually created the logical replication slot and when I created the subscription I used the manually created slot with create_slot=false, I first set up the publication in the source db, and then setup the subscription in the target db, but the target is not updating and I’m not sure why. The pg_replication_slots table in the target db shows that active is false. I’ve tried recreating it but it never goes active. Is this actually possible, to replicate from on db to another in the same cluster? Am I missing something?
—
Jay
Sent from my iPad
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jayknowsunix@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Logical replication issue, pg 13.9
In-Reply-To: <8BBAD76C-AA63-4B2E-ADE4-3835B373E470@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox