Logical replication issue, pg 13.9

From: John Scalia <jayknowsunix(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Logical replication issue, pg 13.9
Date: 2023-11-30 14:59:59
Message-ID: 8BBAD76C-AA63-4B2E-ADE4-3835B373E470@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Sbob 2023-11-30 15:34:12 char column with a single space as the default not working
Previous Message Nadir Pervez 2023-11-28 14:01:32 How to Setup Logical Replication along with Stream Replication