pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Thomas Kellerer <shammat@gmx.net>
To: pgsql-admin@lists.postgresql.org
Subject: How to debug logical replication error "columns are missing" if they are not
Date: Tue, 25 Aug 2020 07:32:09 +0200
Message-ID: <6d2d142f-58b4-d2db-b271-700182b68b55@gmx.net> (raw)

Hello,

we have a a logical replication from Postgres 11 to Postgres 12.

We did some structural changes to the published tables. The changes to the subscriber where applied about 60 minutes later then those on the publisher. Obviously before the subscriber's tables where synced the replication failed.

But even though the tables are now completely identical, the subscriber still claims:

    logical replication target relation "public.employee" is missing some replicated columns

I double checked multiple times that the tables are now identical by doing a diff of the "pg_dump -s" outputs - they are identical in the CREATE TABLE part.

The table is listed with state "r" (ready) in pg_subscription_rel

How can I find out which columns it thinks are missing? And how do I convince the subscriber that the tables *are* identical?

Thanks in advance
Thomas











view thread (5+ messages)  latest in thread

Message-ID: <6d2d142f-58b4-d2db-b271-700182b68b55@gmx.net>
Permalink:  ../6d2d142f-58b4-d2db-b271-700182b68b55@gmx.net/
Also on:    postgresql.org/message-id/6d2d142f-58b4-d2db-b271-700182b68b55@gmx.net

 · 

reply
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: shammat@gmx.net, pgsql-admin@lists.postgresql.org
  Subject: Re: How to debug logical replication error "columns are missing" if they are not
  In-Reply-To: <6d2d142f-58b4-d2db-b271-700182b68b55@gmx.net>

* 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