pg_basebackup restore

Started by PG Bug reporting formabout 1 year ago6 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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.

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: PG Bug reporting form (#1)
Re: pg_basebackup restore

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

#3Anatoly Pugachev
matorola@gmail.com
In reply to: Laurenz Albe (#2)
Re: pg_basebackup restore

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-RECOVERY

Yours,
Laurenz Albe

#4Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Anatoly Pugachev (#3)
Re: pg_basebackup restore

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

#5Anatoly Pugachev
matorola@gmail.com
In reply to: Laurenz Albe (#4)
Re: pg_basebackup restore

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.

#6Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Anatoly Pugachev (#5)
Re: pg_basebackup restore

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