Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
From: John Scalia <jayknowsunix@gmail.com>
Mime-Version: 1.0 (1.0)
Date: Thu, 30 Nov 2023 09:59:59 -0500
Subject: Logical replication issue, pg 13.9
Message-Id: <8BBAD76C-AA63-4B2E-ADE4-3835B373E470@gmail.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Archived-At: 
 <https://www.postgresql.org/message-id/8BBAD76C-AA63-4B2E-ADE4-3835B373E470%40gmail.com>
Precedence: bulk

I=E2=80=99ve got one instance with a couple of databases on it, that my deve=
loper wants one table replicated from one db to another. I manually created t=
he logical replication slot and when I created the subscription I used the m=
anually created slot with create_slot=3Dfalse, I first set up the publicatio=
n in the source db, and then setup the subscription in the target db, but th=
e target is not updating and I=E2=80=99m not sure why. The pg_replication_sl=
ots table in the target db shows that active is false. I=E2=80=99ve tried re=
creating it but it never goes active. Is this actually possible, to replicat=
e from on db to another in the same cluster? Am I missing something?
=E2=80=94
Jay

Sent from my iPad=