Re: Stale description for pg_basebackup
Kyotaro Horiguchi <horikyota.ntt@gmail.com>
From: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
To: pgsql-hackers@lists.postgresql.org
Date: 2021-04-21T01:43:30Z
Lists: pgsql-hackers
Attachments
- fix_pg_basebackup_doc_v2.patch (text/x-patch) patch v2
At Tue, 20 Apr 2021 13:32:35 +0900 (JST), Kyotaro Horiguchi <horikyota.ntt@gmail.com> wrote in > Hello. > > It seems to me that there's a stale description in the documentation > of pg_basebackup. > > https://www.postgresql.org/docs/13/app-pgbasebackup.html > > > Note that there are some limitations in taking a backup from a standby: > ... > > If you are using -X none, there is no guarantee that all WAL files > > required for the backup are archived at the end of backup. > > Actually, pg_basebackup waits for the all required files to be > archived, which is an established behavior by commit > 52f8a59dd9@PG10. However, the same commit seems to have forgot to > change the doc for pg_basebackup. (The current description is > introduced by 9a4d51077c@PG10) > > The attached is a proposal to rewrite it as the following. > > + If you are using -X none, pg_basebackup may wait for a long time for > + all the required WAL files to be archived. In that case, You may need > + to call pg_switch_wal() on the primary to complete it sooner. I forgot to preserve the description about *primary*. It should be as the following instead. + If you are using -X none, there is no guarantee on the primary that + all WAL files required for the backup are archived at the end of + backup. When the standby is configured as archive_mode=always, + pg_basebackup may wait for a long time for all the required WAL files + to be archived. In that case, You may need to call pg_switch_wal() on + the primary to complete it sooner. Attached. regards. -- Kyotaro Horiguchi NTT Open Source Software Center
Commits
-
doc: Fix obsolete description about pg_basebackup.
- d59964999d15 10.17 landed
- 50b84aa26239 11.12 landed
- 0ecc88076ed2 12.7 landed
- 8019fcb00f88 13.3 landed
- eaec48b3c54e 14.0 landed
-
Make pg_stop_backup's wait_for_archive flag work on standbys.
- 52f8a59dd953 10.0 cited