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

Commite35bbea

Browse files
committed
doc: Some improvements in CREATE SUBSCRIPTION ref page
Add link to description of libpq connection strings. Add link toexplanation of replication access control. This currently points to thedescription of streaming replication access control, which is currentlythe same as for logical replication, but that might be refined later.Also remove plain-text passwords from the examples, to not encouragethat dubious practice.based on suggestions from Simon Riggs
1 parentc3c4f6e commite35bbea

File tree

1 file changed

+14
-3
lines changed

1 file changed

+14
-3
lines changed

‎doc/src/sgml/ref/create_subscription.sgml

Lines changed: 14 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -76,7 +76,8 @@ CREATE SUBSCRIPTION <replaceable class="PARAMETER">subscription_name</replaceabl
7676
<term><literal>CONNECTION '<replaceable class="parameter">conninfo</replaceable>'</literal></term>
7777
<listitem>
7878
<para>
79-
The connection string to the publisher.
79+
The connection string to the publisher. For details
80+
see <xref linkend="libpq-connstring">.
8081
</para>
8182
</listitem>
8283
</varlistentry>
@@ -126,6 +127,16 @@ CREATE SUBSCRIPTION <replaceable class="PARAMETER">subscription_name</replaceabl
126127
</variablelist>
127128
</refsect1>
128129

130+
<refsect1>
131+
<title>Notes</title>
132+
133+
<para>
134+
See <xref linkend="streaming-replication-authentication"> for details on
135+
how to configure access control between the subscription and the
136+
publication instance.
137+
</para>
138+
</refsect1>
139+
129140
<refsect1>
130141
<title>Examples</title>
131142

@@ -136,7 +147,7 @@ CREATE SUBSCRIPTION <replaceable class="PARAMETER">subscription_name</replaceabl
136147
commit:
137148
<programlisting>
138149
CREATE SUBSCRIPTION mysub
139-
CONNECTION 'host=192.168.1.50 port=5432 user=foo dbname=foodb password=foopass'
150+
CONNECTION 'host=192.168.1.50 port=5432 user=foo dbname=foodb'
140151
PUBLICATION mypublication, insert_only;
141152
</programlisting>
142153
</para>
@@ -147,7 +158,7 @@ CREATE SUBSCRIPTION mysub
147158
until enabled at a later time.
148159
<programlisting>
149160
CREATE SUBSCRIPTION mysub
150-
CONNECTION 'host=192.168.1.50 port=5432 user=foo dbname=foodb password=foopass'
161+
CONNECTION 'host=192.168.1.50 port=5432 user=foo dbname=foodb'
151162
PUBLICATION insert_only
152163
WITH (DISABLED);
153164
</programlisting>

0 commit comments

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