clarification for pg_basebackup and major versions

Started by PG Bug reporting form3 months ago5 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/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

#2David G. Johnston
david.g.johnston@gmail.com
In reply to: PG Bug reporting form (#1)
Re: clarification for pg_basebackup and major versions

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.

#3Alexey Shishkin
alexey.shishkin@enterprisedb.com
In reply to: David G. Johnston (#2)
Re: clarification for pg_basebackup and major versions

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/&gt;

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
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.pngimage/png; name=image.pngDownload
#4David G. Johnston
david.g.johnston@gmail.com
In reply to: Alexey Shishkin (#3)
Re: clarification for pg_basebackup and major versions

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.

#5Alexey Shishkin
alexey.shishkin@enterprisedb.com
In reply to: David G. Johnston (#4)
Re: clarification for pg_basebackup and major versions

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/&gt;

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 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.pngimage/png; name=image.pngDownload