Check for existing replication slot in pg_createsubscriber

Zane Duffield <duffieldzane@gmail.com>

From: Zane Duffield <duffieldzane@gmail.com>
To: pgsql-hackers@postgresql.org
Date: 2025-06-27T07:42:41Z
Lists: pgsql-hackers
Hackers,

I noticed in testing and usage that pg_createsubscriber doesn't check for
an existing replication slot before attempting to create one, whereas it
*does* check for existing publications.
If it were to check for an existing replication slot, then the --dry-run
mode would be able to detect the issue.

If this seems like a good feature, I'm happy to try and put together a
patch for it.

Thanks,
Zane