Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitfa65c8c

Browse files
committed
doc: Update description of rolreplication column
Since PostgreSQL 9.6, rolreplication no longer determines whether a rolecan run pg_start_backup() and pg_stop_backup(), so remove that.Add that this attribute determines whether a role can create and dropreplication slots.Reported-by: Fujii Masao <masao.fujii@gmail.com>
1 parent22701a7 commitfa65c8c

File tree

2 files changed

+9
-10
lines changed

2 files changed

+9
-10
lines changed

‎doc/src/sgml/catalogs.sgml‎

Lines changed: 4 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -1326,10 +1326,8 @@
13261326
<entry><structfield>rolreplication</structfield></entry>
13271327
<entry><type>bool</type></entry>
13281328
<entry>
1329-
Role is a replication role. That is, this role can initiate streaming
1330-
replication (see <xref linkend="streaming-replication">) and set/unset
1331-
the system backup mode using <function>pg_start_backup</> and
1332-
<function>pg_stop_backup</>
1329+
Role is a replication role. A replication role can initiate replication
1330+
connections and create and drop replication slots.
13331331
</entry>
13341332
</row>
13351333

@@ -9852,10 +9850,8 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx
98529850
<entry><type>bool</type></entry>
98539851
<entry></entry>
98549852
<entry>
9855-
Role is a replication role. That is, this role can initiate streaming
9856-
replication (see <xref linkend="streaming-replication">) and set/unset
9857-
the system backup mode using <function>pg_start_backup</> and
9858-
<function>pg_stop_backup</>
9853+
Role is a replication role. A replication role can initiate replication
9854+
connections and create and drop replication slots.
98599855
</entry>
98609856
</row>
98619857

‎doc/src/sgml/ref/create_role.sgml‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -167,8 +167,11 @@ CREATE ROLE <replaceable class="PARAMETER">name</replaceable> [ [ WITH ] <replac
167167
<term><literal>NOREPLICATION</literal></term>
168168
<listitem>
169169
<para>
170-
These clauses determine whether a role is allowed to initiate
171-
streaming replication or put the system in and out of backup mode.
170+
These clauses determine whether a role is a replication role. A role
171+
must have this attribute (or be a superuser) in order to be able to
172+
connect to the server in replication mode (physical or logical
173+
replication) and in order to be able to create or drop replication
174+
slots.
172175
A role having the <literal>REPLICATION</> attribute is a very
173176
highly privileged role, and should only be used on roles actually
174177
used for replication. If not specified,

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp