Re: Need Force flag for pg_drop_replication_slot()

From: Andres Freund <andres(at)anarazel(dot)de>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Need Force flag for pg_drop_replication_slot()
Date: 2015-05-29 19:27:41
Message-ID: 20150529192741.GG26863@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2015-05-29 12:08:24 -0700, Josh Berkus wrote:
> Now, BDR is good because it sets an application_name which lets me
> figure out what's using the replication slot. But that's by no means
> required; other LC plug-ins, I expect, do not do so. So there's no way
> for the user to figure out which replication connection relates to which
> slots, as far as I can tell.
>
> In this test, it's easy because there's only one replication connection
> and one slot. But imagine the case of 14 replication connections with
> their own slots. How could you possibly figure out which one was the
> laggy one?

9.5 shows the pid.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2015-05-29 19:30:42 Re: RFC: Remove contrib entirely
Previous Message Andres Freund 2015-05-29 19:27:18 Re: Need Force flag for pg_drop_replication_slot()