pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Daniel Gustafsson <daniel@yesql.se>
To: pgsql-docs@lists.postgresql.org
Subject: Roles for pg_basebackup
Date: Mon, 27 Apr 2020 12:16:41 +0200
Message-ID: <ECEBD212-7101-41EB-84F3-2F356E4B6401@yesql.se> (raw)

Based on a recent conversation about backups I had I propose a small tweak to
the pg_basebackup documentation.  Listing the user types in the reverse order
from today, putting superuser last, makes it IMO a little clearer that a
REPLICATION role is preferrable to using a superuser for running backups.

cheers ./daniel

Attachments:


pg_basebackup_user.diff (application/octet-stream, 878B) download
diff --git a/doc/src/sgml/ref/pg_basebackup.sgml b/doc/src/sgml/ref/pg_basebackup.sgml
index 01ce44ee22..12fadabfb8 100644
--- a/doc/src/sgml/ref/pg_basebackup.sgml
+++ b/doc/src/sgml/ref/pg_basebackup.sgml
@@ -51,8 +51,8 @@ PostgreSQL documentation
   <para>
    The backup is made over a regular <productname>PostgreSQL</productname>
    connection, and uses the replication protocol. The connection must be made
-   with a superuser or a user having <literal>REPLICATION</literal>
-   permissions (see <xref linkend="role-attributes"/>),
+   with a user having <literal>REPLICATION</literal> permissions
+   (see <xref linkend="role-attributes"/>) or a superuser,
    and <filename>pg_hba.conf</filename> must explicitly permit the replication
    connection. The server must also be configured
    with <xref linkend="guc-max-wal-senders"/> set high enough to leave at least

view thread (7+ messages)  latest in thread

Message-ID: <ECEBD212-7101-41EB-84F3-2F356E4B6401@yesql.se>
Permalink:  ../ECEBD212-7101-41EB-84F3-2F356E4B6401@yesql.se/
Also on:    postgresql.org/message-id/ECEBD212-7101-41EB-84F3-2F356E4B6401@yesql.se

 ·  · 

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: pgsql-docs@postgresql.org
  Cc: daniel@yesql.se, pgsql-docs@lists.postgresql.org
  Subject: Re: Roles for pg_basebackup
  In-Reply-To: <ECEBD212-7101-41EB-84F3-2F356E4B6401@yesql.se>

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

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