public inbox for [email protected]  

help / color / mirror / Atom feed

From: Martin Marques <[email protected]>
To: [email protected]
Subject: replication slots only need user with replication for creation
Date: Thu, 23 Aug 2018 21:41:07 -0300
Message-ID: <[email protected]> (raw)

Hi,

Looking at privileges that a user would need now a days to create a
cluster clone with repmgr we noticed that there's inaccurate information
in the docs regarding the use of replication functions.

I was able to test on 9.6 and 10 that a user with replication privileges
can create and drop a replication slot.

But in the system administration functions, section replication
functions it states:

The functions shown in Table 9.83 are for controlling and interacting
with replication features. See Section 26.2.5, Section 26.2.6, and
Chapter 49 for information about the underlying features. Use of these
functions is restricted to superusers.

Source:
https://www.postgresql.org/docs/10/static/functions-admin.html#FUNCTIONS-REPLICATION

I suggest amending this with a text like the following:

The functions shown in Table 9.83 are for controlling and interacting
with replication features. See Section 26.2.5, Section 26.2.6, and
Chapter 49 for information about the underlying features. Use of these
functions is restricted to superusers and users with replication privileges.

I think this doc patch should be back-patched

Regards,

-- 
Martín Marqués                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: replication slots only need user with replication for creation
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox