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:
...
Show quoted text
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-RECOVERYYours,
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-RECOVERYI 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-RECOVERYI 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-RECOVERYI 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