Check for existing replication slot in pg_createsubscriber

From: Zane Duffield <duffieldzane(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Check for existing replication slot in pg_createsubscriber
Date: 2025-06-27 07:42:41
Message-ID: CACMiCkWB=4OaQUQEBs5MhiFXeSmTGgkNcWSimiwH05JFaF=ERw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message shveta malik 2025-06-27 08:07:20 Re: Conflict detection for update_deleted in logical replication
Previous Message sundayjiang (蒋浩天) 2025-06-27 07:32:55 [PATCH] Prevent replacement of a function if it's used in an index expression and is not IMMUTABLE