pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedDocumentation does not mention that basebackup could not be used on newer major version
4+ messages / 4 participants
[nested] [flat]
* Documentation does not mention that basebackup could not be used on newer major version
@ 2023-09-18 15:29 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 4+ messages in thread
From: PG Doc comments form @ 2023-09-18 15:29 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: konkove@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/app-pgbasebackup.html
Description:
https://www.postgresql.org/docs/current/logical-replication.html
Logical replication has excellent paragraph about usecases.
These pages does not have them.
https://www.postgresql.org/docs/current/app-pgdump.html
https://www.postgresql.org/docs/current/app-pgbasebackup.html
My main issue is that `pg_basebackup` page does not mention that this backup
is compatible only with current version of database. I can not do basebackup
on v11 and restore that on v15, for example.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Documentation does not mention that basebackup could not be used on newer major version
@ 2023-09-18 20:08 Laurenz Albe <laurenz.albe@cybertec.at>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 2 replies; 4+ messages in thread
From: Laurenz Albe @ 2023-09-18 20:08 UTC (permalink / raw)
To: konkove@gmail.com; pgsql-docs@lists.postgresql.org
On Mon, 2023-09-18 at 15:29 +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/16/app-pgbasebackup.html
> Description:
>
> https://www.postgresql.org/docs/current/logical-replication.html
> Logical replication has excellent paragraph about usecases.
>
> These pages does not have them.
> https://www.postgresql.org/docs/current/app-pgdump.html
> https://www.postgresql.org/docs/current/app-pgbasebackup.html
>
> My main issue is that `pg_basebackup` page does not mention that this backup
> is compatible only with current version of database. I can not do basebackup
> on v11 and restore that on v15, for example.
I think that that is amply documented by the fact that pg_basebackup is
*not* mentioned in https://www.postgresql.org/docs/current/upgrading.html .
You can't expect us to enumerate every tool that is not suitable for
upgrading.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Documentation does not mention that basebackup could not be used on newer major version
@ 2023-09-18 22:12 Eugen Konkov <konkove@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 0 replies; 4+ messages in thread
From: Eugen Konkov @ 2023-09-18 22:12 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-docs@lists.postgresql.org
Did not know that page even exists.
No need to enumerate. It would be nice if you mention that `This tool is
not suitable for restoring data in different major version`.
On Mon, Sep 18, 2023 at 4:08 PM Laurenz Albe <laurenz.albe@cybertec.at>
wrote:
> On Mon, 2023-09-18 at 15:29 +0000, PG Doc comments form wrote:
> > The following documentation comment has been logged on the website:
> >
> > Page: https://www.postgresql.org/docs/16/app-pgbasebackup.html
> > Description:
> >
> > https://www.postgresql.org/docs/current/logical-replication.html
> > Logical replication has excellent paragraph about usecases.
> >
> > These pages does not have them.
> > https://www.postgresql.org/docs/current/app-pgdump.html
> > https://www.postgresql.org/docs/current/app-pgbasebackup.html
> >
> > My main issue is that `pg_basebackup` page does not mention that this
> backup
> > is compatible only with current version of database. I can not do
> basebackup
> > on v11 and restore that on v15, for example.
>
> I think that that is amply documented by the fact that pg_basebackup is
> *not* mentioned in https://www.postgresql.org/docs/current/upgrading.html
> .
>
> You can't expect us to enumerate every tool that is not suitable for
> upgrading.
>
> Yours,
> Laurenz Albe
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Documentation does not mention that basebackup could not be used on newer major version
@ 2023-09-19 00:02 Michael Paquier <michael@paquier.xyz>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 0 replies; 4+ messages in thread
From: Michael Paquier @ 2023-09-19 00:02 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: konkove@gmail.com; pgsql-docs@lists.postgresql.org
On Mon, Sep 18, 2023 at 10:08:30PM +0200, Laurenz Albe wrote:
> On Mon, 2023-09-18 at 15:29 +0000, PG Doc comments form wrote:
>> My main issue is that `pg_basebackup` page does not mention that this backup
>> is compatible only with current version of database. I can not do basebackup
>> on v11 and restore that on v15, for example.
>
> I think that that is amply documented by the fact that pg_basebackup is
> *not* mentioned in https://www.postgresql.org/docs/current/upgrading.html .
Yeah. The issue with this one is that it does a direct physical copy
of the files. You cannot expect pg_basebackup to be able to do all
the work that pg_upgrade would do underground, like binary upgrades,
and more.
> You can't expect us to enumerate every tool that is not suitable for
> upgrading.
Just noting in passing. There is a lot of maintenance effort for
downward compatibility (tools like pg_dump and pg_basebackup at
version N are able to work with a backend version older, say at N-1).
Upward compabitility may work in some cases, even for dumps, still
these would likely require extra manipulation to be able to load to
a version of the backend older than the version of pg_dump used.
Being able to use pg_basebackup to work with older backend versions is
a really important property we try to keep available.
--
Michael
Attachments:
[application/pgp-signature] signature.asc (832B, ../../ZQjlK-Eh6w6Vo712@paquier.xyz/2-signature.asc)
download
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2023-09-19 00:02 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-09-18 15:29 Documentation does not mention that basebackup could not be used on newer major version PG Doc comments form <noreply@postgresql.org>
2023-09-18 20:08 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-18 22:12 ` Eugen Konkov <konkove@gmail.com>
2023-09-19 00:02 ` Michael Paquier <michael@paquier.xyz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox