Re: Replication slots and footguns - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Replication slots and footguns
Date
Msg-id CA+Tgmoa3JcHPcbXo1426aQ2itkz1brv28181nvp06Fg=3eMriw@mail.gmail.com
Whole thread Raw
In response to Re: Replication slots and footguns  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On Thu, Mar 13, 2014 at 1:03 PM, Josh Berkus <josh@agliodbs.com> wrote:
> On 03/13/2014 04:07 AM, Andres Freund wrote:
>> On 2014-03-12 13:34:47 -0700, Josh Berkus wrote:
>>> On 03/12/2014 12:34 PM, Robert Haas wrote:
>>>>>> Urgh.  That error message looks susceptible to improvement.  How about:
>>>>>>>>
>>>>>>>> replication slot "%s" cannot be dropped because it is currently in use
>>>>>>
>>>>>> I think that'd require duplicating some code between acquire and drop,
>>>>>> but how about "replication slot "%s" is in use by another backend"?
>>>> Sold.
>>>
>>> Wait ... before you go further ... I object to dropping the word
>>> "active" from the error message.  The column is called "active", and
>>> that's where a DBA should look; that word needs to stay in the error
>>> message.
>>
>> "replication slot "%s" is in active in another backend"?
>
> "*for* another backend", but that works for me.  I just want to keep the
> word "active", because when I encountered that error in testing I knew
> *immediately* where to look because of the word.

I think "in use" is just as clear as active, and I think the text
Andres proposed previously reads a whole lot more nicely than this:

replication slot "%s" is in use by another backend

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: gaussian distribution pgbench
Next
From: Robert Haas
Date:
Subject: Re: [PATCH] Store Extension Options