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

Commitfdf89f7

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 parente2e3984 commitfdf89f7

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
@@ -1280,10 +1280,8 @@
12801280
<entry><structfield>rolreplication</structfield></entry>
12811281
<entry><type>bool</type></entry>
12821282
<entry>
1283-
Role is a replication role. That is, this role can initiate streaming
1284-
replication (see <xref linkend="streaming-replication">) and set/unset
1285-
the system backup mode using <function>pg_start_backup</> and
1286-
<function>pg_stop_backup</>
1283+
Role is a replication role. A replication role can initiate replication
1284+
connections and create and drop replication slots.
12871285
</entry>
12881286
</row>
12891287

@@ -8906,10 +8904,8 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx
89068904
<entry><type>bool</type></entry>
89078905
<entry></entry>
89088906
<entry>
8909-
Role is a replication role. That is, this role can initiate streaming
8910-
replication (see <xref linkend="streaming-replication">) and set/unset
8911-
the system backup mode using <function>pg_start_backup</> and
8912-
<function>pg_stop_backup</>
8907+
Role is a replication role. A replication role can initiate replication
8908+
connections and create and drop replication slots.
89138909
</entry>
89148910
</row>
89158911

‎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