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

Commiteaec48b

Browse files
committed
doc: Fix obsolete description about pg_basebackup.
Previously it was documented that if using "-X none" option there wasno guarantee that all required WAL files were archived at the end ofpg_basebackup when taking a backup from the standby. But this limitationwas removed by commit52f8a59. Now, even when taking a backupfrom the standby, pg_basebackup can wait for all required WAL filesto be archived. Therefore this commit removes such obsoletedescription from the docs.Also this commit adds new description about the limitation whentaking a backup from the standby, into the docs. The limitation is thatpg_basebackup cannot force the standbfy to switch to a new WAL fileat the end of backup, which may cause pg_basebackup to wait a longtime for the last required WAL file to be switched and archived,especially when write activity on the primary is low.Back-patch to v10 where the issue was introduced.Reported-by: Kyotaro HoriguchiAuthor: Kyotaro Horiguchi, Fujii MasaoReviewed-by: Kyotaro Horiguchi, Fujii MasaoDiscussion:https://postgr.es/m/20210420.133235.1342729068750553399.horikyota.ntt@gmail.com
1 parent7776a23 commiteaec48b

File tree

1 file changed

+8
-2
lines changed

1 file changed

+8
-2
lines changed

‎doc/src/sgml/ref/pg_basebackup.sgml

Lines changed: 8 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -83,8 +83,14 @@ PostgreSQL documentation
8383
</listitem>
8484
<listitem>
8585
<para>
86-
If you are using <literal>-X none</literal>, there is no guarantee that all
87-
WAL files required for the backup are archived at the end of backup.
86+
<application>pg_basebackup</application> cannot force the standby
87+
to switch to a new WAL file at the end of backup.
88+
When you are using <literal>-X none</literal>, if write activity on
89+
the primary is low, <application>pg_basebackup</application> may
90+
need to wait a long time for the last WAL file required for the backup
91+
to be switched and archived. In this case, it may be useful to run
92+
<function>pg_switch_wal</function> on the primary in order to
93+
trigger an immediate WAL file switch.
8894
</para>
8995
</listitem>
9096
<listitem>

0 commit comments

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