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-21T02:09:37Z
Lists: pgsql-hackers
Attachments
- fix_pg_basebackup_doc_v3.patch (text/x-patch) patch v3
At Wed, 21 Apr 2021 10:43:30 +0900 (JST), Kyotaro Horiguchi <horikyota.ntt@gmail.com> wrote in > 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. Hmm. Some words need to be qualified. 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