diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2018-04-11 09:01:57 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2018-04-11 09:02:34 -0400 |
| commit | 93e60b9494672ee49bbba8b485ef9d3c76fe3a20 (patch) | |
| tree | 07840861827057dc53ec44dd899789feea33f4a4 | |
| parent | 02ba72ec1cf541d735c993f11342784969f65b45 (diff) | |
| download | postgresql-93e60b9494672ee49bbba8b485ef9d3c76fe3a20.tar.gz postgresql-93e60b9494672ee49bbba8b485ef9d3c76fe3a20.zip | |
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>
| -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> |