The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-droppublication.html Description:
Hi, I'm using a lot the logical replication. I have to do some DDL changes, via an automatic process, on the primary. That process drop the existing publication, which will stop the subscription. I kept the LSN information on the primary, perform the DDL changes on the replica. Than I recreate the publication, use the pg_replication_slot_advance using the savec LSN. When I re-enable the subscription, I have an error message in the postgres log saying that the publication doesn't exist. However, it does have the same name. Can a note be added on the "DROP PUBLICATION" page to mention that dropping a publication will compromise the logical replication process event if the publication is recreated with the same name. Thanks.