diff options
| author | Peter Eisentraut | 2018-04-11 13:01:57 +0000 |
|---|---|---|
| committer | Peter Eisentraut | 2018-04-11 13:02:34 +0000 |
| commit | 93e60b9494672ee49bbba8b485ef9d3c76fe3a20 (patch) | |
| tree | 07840861827057dc53ec44dd899789feea33f4a4 /doc/src/sgml | |
| parent | 02ba72ec1cf541d735c993f11342784969f65b45 (diff) | |
doc: Add more information about logical replication privileges
In particular, the requirement to have SELECT privilege for the initial
table copy was previously not documented.
Author: Shinoda, Noriyoshi <noriyoshi.shinoda@hpe.com>
Diffstat (limited to 'doc/src/sgml')
| -rw-r--r-- | doc/src/sgml/logical-replication.sgml | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/doc/src/sgml/logical-replication.sgml b/doc/src/sgml/logical-replication.sgml index fa0bb56b7bf..83795f036a6 100644 --- a/doc/src/sgml/logical-replication.sgml +++ b/doc/src/sgml/logical-replication.sgml @@ -486,7 +486,14 @@ <para> The role used for the replication connection must have the <literal>REPLICATION</literal> attribute (or be a superuser). Access for the role must be - configured in <filename>pg_hba.conf</filename>. + configured in <filename>pg_hba.conf</filename> and it must have the + <literal>LOGIN</literal> attribute. + </para> + + <para> + In order to be able to copy the initial table data, the role used for the + replication connection must have the <literal>SELECT</literal> privilege on + a published table (or be a superuser). </para> <para> |