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:01:57 -0400 |
| commit | f1f537cb46299d81abb08258fd322f72170dff58 (patch) | |
| tree | aeaee777585963bc7f1cc9c6294f1c62472ee1f7 | |
| parent | 036ca6f7bb186ae8564fb9e3a27852757a9450be (diff) | |
| download | postgresql-f1f537cb46299d81abb08258fd322f72170dff58.tar.gz postgresql-f1f537cb46299d81abb08258fd322f72170dff58.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 151e773fc2c..16ba9c40811 100644 --- a/doc/src/sgml/logical-replication.sgml +++ b/doc/src/sgml/logical-replication.sgml @@ -477,7 +477,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> |