pg_subscription_rel
pg_publication_rel
have the relation part of the publication concerned.
OP has an issue to figure out if publication has a list of tables not in
sync in subscription and has subscription broken.
there may be ways to query tables on subscriber dbs via dblink or fdw,
but there is
On Thu, Jun 10, 2021 at 12:39 PM Vijaykumar Jain <
vijaykumarjain.git...@gmail.com> wrote:
> Wow, the drop table silently removes entry from publication without any
> logs.
>
> I could not find any monitoring view to help me figure out if the
> publication is broken due to ddl change.
> pg_stat_re
Wow, the drop table silently removes entry from publication without any
logs.
I could not find any monitoring view to help me figure out if the
publication is broken due to ddl change.
pg_stat_replication on publisher, and pg_stat_subscription on
subscriber only help with lsn based lag.
unless thi
Hi Experts
I had a case where a team member deleted and recreated an empty table which
participated in logical replication. After that action the table no longer was
part of the replication and new inserts were not copied to the subscribers.
How can I check existing publication for the list o
