public inbox for pgsql-docs@postgresql.org
help / color / mirror / Atom feedclarification for pg_basebackup and major versions
5+ messages / 3 participants
[nested] [flat]
* clarification for pg_basebackup and major versions
@ 2025-12-29 20:45 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 5+ messages in thread
From: PG Doc comments form @ 2025-12-29 20:45 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: alexey.shishkin@enterprisedb.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/18/app-pgbasebackup.html
Description:
Hi, Team !
Could we pls. clarify the following statement on the documentation page
https://www.postgresql.org/docs/18/app-pgbasebackup.html:
'pg_basebackup works with servers of the same or older major version, down
to 9.1.'
What does it exactly mean 'works with servers of the same or older major
version' ?
Most probably it means the possibility to use pg_basebackup binary of
version PG 17 to take backup of PG 14 server. Or something else ?
But it's definitely not ability to use pg_basebackup for PostgreSQL major
version upgrade, since pg_basebackup is not listed among the supported
options in https://www.postgresql.org/docs/18/upgrading.html
So, pls. let me propose two things:
- to clarify how pg_basebackup works with servers of the same or older major
version
- to clearly specify pg_basebackup cannot be used for PostgreSQL major
version upgrade
It could be done on the same page
https://www.postgresql.org/docs/18/app-pgbasebackup.html
Thanks !
best regards
Alexey Shishkin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: clarification for pg_basebackup and major versions
@ 2025-12-31 13:34 David G. Johnston <david.g.johnston@gmail.com>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 5+ messages in thread
From: David G. Johnston @ 2025-12-31 13:34 UTC (permalink / raw)
To: alexey.shishkin@enterprisedb.com <alexey.shishkin@enterprisedb.com>; pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
On Monday, December 29, 2025, PG Doc comments form <noreply@postgresql.org>
wrote:
>
> - to clarify how pg_basebackup works with servers of the same or older
> major
> version
There is no “how”, it just does. The documentation is versioned and “it”
means the binary produced by that version.
> - to clearly specify pg_basebackup cannot be used for PostgreSQL major
> version upgrade
The page clearly states what a backup can be used for and upgrade is not
listed.
David J.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: clarification for pg_basebackup and major versions
@ 2026-01-19 18:01 Alexey Shishkin <alexey.shishkin@enterprisedb.com>
parent: David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Alexey Shishkin @ 2026-01-19 18:01 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Hi, Team !
Some more clarification about pg_basebackup which should be available in
the documentation:
- if pg_basebackup works between different versions of the same OS (ex.
RHEL8 and RHEL9)
- if pg_basebackup works between different types of OS Linux (ex. RHEL10
and Debian13) or OS Windows (ex. Windows 2016 and Windows 2019)
- if pg_basebackup works between different types of OS (ex. Ubuntu 24.04
and Windows 2022)
- if pg_basebackup works between different platforms (ex. Linux on amd64
and Linux on arm64)
- if pg_basebackup works between 32-bit OS and 64-bit OS
best regards,
Alexey Shishkin
[image: image.png]
*Alexey Shishkin*
Technical Account Manager
EDB Software GmbH
alexey.shishkin@enterprisedb.com
www.enterprisedb.com <https://enterprisedb.com/;
On Wed, Dec 31, 2025 at 2:34 PM David G. Johnston <
david.g.johnston@gmail.com> wrote:
>
>
> On Monday, December 29, 2025, PG Doc comments form <noreply@postgresql.org>
> wrote:
>
>>
>> - to clarify how pg_basebackup works with servers of the same or older
>> major
>> version
>
>
> There is no “how”, it just does. The documentation is versioned and “it”
> means the binary produced by that version.
>
>
>> - to clearly specify pg_basebackup cannot be used for PostgreSQL major
>> version upgrade
>
>
> The page clearly states what a backup can be used for and upgrade is not
> listed.
>
> David J.
>
>
Attachments:
[image/png] image.png (13.2K, 3-image.png)
download | view image
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: clarification for pg_basebackup and major versions
@ 2026-01-19 18:23 David G. Johnston <david.g.johnston@gmail.com>
parent: Alexey Shishkin <alexey.shishkin@enterprisedb.com>
0 siblings, 1 reply; 5+ messages in thread
From: David G. Johnston @ 2026-01-19 18:23 UTC (permalink / raw)
To: Alexey Shishkin <alexey.shishkin@enterprisedb.com>; +Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
On Monday, January 19, 2026, Alexey Shishkin <
alexey.shishkin@enterprisedb.com> wrote:
> Hi, Team !
>
> Some more clarification about pg_basebackup which should be available in
> the documentation:
>
> - if pg_basebackup works between different versions of the same OS (ex.
> RHEL8 and RHEL9)
> - if pg_basebackup works between different types of OS Linux (ex. RHEL10
> and Debian13) or OS Windows (ex. Windows 2016 and Windows 2019)
> - if pg_basebackup works between different types of OS (ex. Ubuntu 24.04
> and Windows 2022)
> - if pg_basebackup works between different platforms (ex. Linux on amd64
> and Linux on arm64)
> - if pg_basebackup works between 32-bit OS and 64-bit OS
>
>>
>>
Please don’t top-post.
I agree this these dynamics aren’t readily exposed in the documentation. I
disagree that pg_basebackup should be considered as an authoritative
location for covering the material. It would simply link to such a
location in notes or “see also”.
In short, though, it like pretty much any client program will function
correctly regardless of differences with the server. But a physical backup
is only truly promised to work if the environment that is processing the
data matches the environment that produced the data.
David J.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: clarification for pg_basebackup and major versions
@ 2026-01-21 09:04 Alexey Shishkin <alexey.shishkin@enterprisedb.com>
parent: David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Alexey Shishkin @ 2026-01-21 09:04 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Hi, Team !
Thanks for your reply !
What I see in the fields is the lack of such simple
supported/recommended/prerequisites notes/links in the official PostgreSQL
documentation (pg_backup is just an example).
That might lead to further confusion for PostgreSQL users.
As an example pls. let me share the logical replication documentation
https://www.postgresql.org/docs/current/logical-replication.html which says:
'
...
- Replicating between different major versions of PostgreSQL.
- Replicating between PostgreSQL instances on different platforms (for
example Linux to Windows)
...
'
I do believe something similar about pg_basebackup would be very welcome by
PostgreSQL users.
best regards,
Alexey Shishkin
[image: image.png]
*Alexey Shishkin*
Technical Account Manager
EDB Software GmbH
alexey.shishkin@enterprisedb.com
www.enterprisedb.com <https://enterprisedb.com/;
On Mon, Jan 19, 2026 at 7:23 PM David G. Johnston <
david.g.johnston@gmail.com> wrote:
> On Monday, January 19, 2026, Alexey Shishkin <
> alexey.shishkin@enterprisedb.com> wrote:
>
>> Hi, Team !
>>
>> Some more clarification about pg_basebackup which should be available in
>> the documentation:
>>
>> - if pg_basebackup works between different versions of the same OS (ex.
>> RHEL8 and RHEL9)
>> - if pg_basebackup works between different types of OS Linux (ex. RHEL10
>> and Debian13) or OS Windows (ex. Windows 2016 and Windows 2019)
>> - if pg_basebackup works between different types of OS (ex. Ubuntu 24.04
>> and Windows 2022)
>> - if pg_basebackup works between different platforms (ex. Linux on amd64
>> and Linux on arm64)
>> - if pg_basebackup works between 32-bit OS and 64-bit OS
>>
>>>
>>>
> Please don’t top-post.
>
> I agree this these dynamics aren’t readily exposed in the documentation.
> I disagree that pg_basebackup should be considered as an authoritative
> location for covering the material. It would simply link to such a
> location in notes or “see also”.
>
> In short, though, it like pretty much any client program will function
> correctly regardless of differences with the server. But a physical backup
> is only truly promised to work if the environment that is processing the
> data matches the environment that produced the data.
>
> David J.
>
Attachments:
[image/png] image.png (13.2K, 3-image.png)
download | view image
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2026-01-21 09:04 UTC | newest]
Thread overview: 5+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-12-29 20:45 clarification for pg_basebackup and major versions PG Doc comments form <noreply@postgresql.org>
2025-12-31 13:34 ` David G. Johnston <david.g.johnston@gmail.com>
2026-01-19 18:01 ` Alexey Shishkin <alexey.shishkin@enterprisedb.com>
2026-01-19 18:23 ` David G. Johnston <david.g.johnston@gmail.com>
2026-01-21 09:04 ` Alexey Shishkin <alexey.shishkin@enterprisedb.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox