Thread: pg_basebackup restore
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/app-pgbasebackup.html Description: Hello! Is there any way to restore pg_basebackup ? Reading current documentation on pg_basebackup I could not find any "restore" word in it. Thank you.
On Sun, 2025-03-02 at 09:27 +0000, PG Doc comments form wrote: > Is there any way to restore pg_basebackup ? Reading current documentation on > pg_basebackup I could not find any "restore" word in it. Try looking for "recovery": https://www.postgresql.org/docs/current/continuous-archiving.html#BACKUP-PITR-RECOVERY Yours, Laurenz Albe
Laurenz, I mean it's a completely different page, but the pg_basebackup page has an examples section. Or please put a link to pg_basebackup page to restore/recovery page (continuous-archiving.html), explaining how to restore a backup. But actually, would be nice to put to the examples section of the pg_basebackup page. Examples: - Take a backup with pg_basebackup: ... - Restore backup taken with pg_basebackup: ... On Tue, Mar 4, 2025 at 12:02 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote: > > On Sun, 2025-03-02 at 09:27 +0000, PG Doc comments form wrote: > > Is there any way to restore pg_basebackup ? Reading current documentation on > > pg_basebackup I could not find any "restore" word in it. > > Try looking for "recovery": > https://www.postgresql.org/docs/current/continuous-archiving.html#BACKUP-PITR-RECOVERY > > Yours, > Laurenz Albe
On Wed, 2025-03-05 at 13:11 +0400, Anatoly Pugachev wrote: > On Tue, Mar 4, 2025 at 12:02 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote: > > On Sun, 2025-03-02 at 09:27 +0000, PG Doc comments form wrote: > > > Is there any way to restore pg_basebackup ? Reading current documentation on > > > pg_basebackup I could not find any "restore" word in it. > > > > Try looking for "recovery": > > https://www.postgresql.org/docs/current/continuous-archiving.html#BACKUP-PITR-RECOVERY > > I mean it's a completely different page, but the pg_basebackup page > has an examples section. Or please put a link to pg_basebackup page to > restore/recovery page (continuous-archiving.html), explaining how to > restore a backup. > > But actually, would be nice to put to the examples section of the > pg_basebackup page. A hyperlink might be a good idea. I think that recovery is too complicted to be described on the "pg_basebackup" reference page. Yours, Laurenz Albe
On Wed, Mar 5, 2025 at 1:50 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote: > On Wed, 2025-03-05 at 13:11 +0400, Anatoly Pugachev wrote: > > On Tue, Mar 4, 2025 at 12:02 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote: > > > On Sun, 2025-03-02 at 09:27 +0000, PG Doc comments form wrote: > > > > Is there any way to restore pg_basebackup ? Reading current documentation on > > > > pg_basebackup I could not find any "restore" word in it. > > > > > > Try looking for "recovery": > > > https://www.postgresql.org/docs/current/continuous-archiving.html#BACKUP-PITR-RECOVERY > > > > I mean it's a completely different page, but the pg_basebackup page > > has an examples section. Or please put a link to pg_basebackup page to > > restore/recovery page (continuous-archiving.html), explaining how to > > restore a backup. > > > > But actually, would be nice to put to the examples section of the > > pg_basebackup page. > > A hyperlink might be a good idea. > > I think that recovery is too complicted to be described on the > "pg_basebackup" reference page. Laurenz Albe, thank you. If you can do anything about it, thanks again.
On Wed, 2025-03-05 at 14:48 +0400, Anatoly Pugachev wrote: > > > > > Is there any way to restore pg_basebackup ? Reading current documentation on > > > > > pg_basebackup I could not find any "restore" word in it. > > > > > > > > Try looking for "recovery": > > > > https://www.postgresql.org/docs/current/continuous-archiving.html#BACKUP-PITR-RECOVERY > > > > > > I mean it's a completely different page, but the pg_basebackup page > > > has an examples section. Or please put a link to pg_basebackup page to > > > restore/recovery page (continuous-archiving.html), explaining how to > > > restore a backup. > > > > > > But actually, would be nice to put to the examples section of the > > > pg_basebackup page. > > > > A hyperlink might be a good idea. > > thank you. If you can do anything about it, thanks again. Looking again, there is such a link in the very first paragraph of the "Description" section: The backup is taken without affecting other clients of the database, and can be used both for point-in-time recovery (see Section 25.3) ^ the link that I mean and as the starting point for a log-shipping or streaming-replication standby server (see Section 26.2). So I don't really see how that could be any better. Yours, Laurenz Albe