agora inbox for pgsql-docs@postgresql.org
help / color / mirror / Atom feedpg_basebackup restore
6+ messages / 3 participants
[nested] [flat]
* pg_basebackup restore
@ 2025-03-02 09:27 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 6+ messages in thread
From: PG Doc comments form @ 2025-03-02 09:27 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: matorola@gmail.com
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_basebackup restore
@ 2025-03-03 20:02 Laurenz Albe <laurenz.albe@cybertec.at>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 6+ messages in thread
From: Laurenz Albe @ 2025-03-03 20:02 UTC (permalink / raw)
To: matorola@gmail.com; pgsql-docs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_basebackup restore
@ 2025-03-05 09:11 Anatoly Pugachev <matorola@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 6+ messages in thread
From: Anatoly Pugachev @ 2025-03-05 09:11 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-docs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_basebackup restore
@ 2025-03-05 09:50 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Anatoly Pugachev <matorola@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Laurenz Albe @ 2025-03-05 09:50 UTC (permalink / raw)
To: Anatoly Pugachev <matorola@gmail.com>; +Cc: pgsql-docs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_basebackup restore
@ 2025-03-05 10:48 Anatoly Pugachev <matorola@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 6+ messages in thread
From: Anatoly Pugachev @ 2025-03-05 10:48 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-docs@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_basebackup restore
@ 2025-03-05 11:43 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Anatoly Pugachev <matorola@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Laurenz Albe @ 2025-03-05 11:43 UTC (permalink / raw)
To: Anatoly Pugachev <matorola@gmail.com>; +Cc: pgsql-docs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2025-03-05 11:43 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-03-02 09:27 pg_basebackup restore PG Doc comments form <noreply@postgresql.org>
2025-03-03 20:02 ` Laurenz Albe <laurenz.albe@cybertec.at>
2025-03-05 09:11 ` Anatoly Pugachev <matorola@gmail.com>
2025-03-05 09:50 ` Laurenz Albe <laurenz.albe@cybertec.at>
2025-03-05 10:48 ` Anatoly Pugachev <matorola@gmail.com>
2025-03-05 11:43 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox