I created a logical replication PUBLICATION using
FOR ALL TABLES. Now I've realized I don't want to replicate all of the tables after all. I tried dropping one of the tables from the publication, but:
mydb=# alter publication replicapublication drop table only migrations; ERROR: publication "replicapublication" is defined as FOR ALL TABLES DETAIL: Tables cannot be added to or dropped from FOR ALL TABLES publications.
I've done a huge sync of hundreds of GB, and I don't want to start over with a new publication.
Questions: 1. Is there any hope of redeeming this publication? 2. If not, is there any way to create a new publication that's fully synced without starting over with a full sync?