Обсуждение: clarification for pg_basebackup and major versions

Поиск
Список
Период
Сортировка

clarification for pg_basebackup and major versions

От
PG Doc comments form
Дата:
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

Re: clarification for pg_basebackup and major versions

От
"David G. Johnston"
Дата:


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.

Re: clarification for pg_basebackup and major versions

От
Alexey Shishkin
Дата:
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.png

 

Alexey Shishkin

Technical Account Manager

EDB Software GmbH

alexey.shishkin@enterprisedb.com

 

www.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.

Вложения

Re: clarification for pg_basebackup and major versions

От
"David G. Johnston"
Дата:
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.

Re: clarification for pg_basebackup and major versions

От
Alexey Shishkin
Дата:
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.png

 

Alexey Shishkin

Technical Account Manager

EDB Software GmbH

alexey.shishkin@enterprisedb.com

 

www.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.
Вложения