clarification for pg_basebackup and major versions
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
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.
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:
Show quoted text
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
versionThere 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 upgradeThe page clearly states what a backup can be used for and upgrade is not
listed.David J.
Attachments:
image.pngimage/png; name=image.pngDownload
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.
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:
Show quoted text
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 OSPlease 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.