replication slots only need user with replication for creation

From: Martin Marques <martin(dot)marques(at)2ndquadrant(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: replication slots only need user with replication for creation
Date: 2018-08-24 00:41:07
Message-ID: 9e656b3b-0a18-780c-6bca-7270463a2128@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

Browse pgsql-docs by date

  From Date Subject
Next Message Jürgen Purtz 2018-08-24 09:40:19 Re: "System roles" mentioned in psql documentation
Previous Message Michael Paquier 2018-08-24 00:21:11 Re: "System roles" mentioned in psql documentation