Feedback-ID: i0fe9450f:Fastmail
Date: Tue, 19 Sep 2023 09:02:51 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: konkove@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: Documentation does not mention that basebackup could not be used
 on newer major version
Message-ID: <ZQjlK-Eh6w6Vo712@paquier.xyz>
References: 
 <169505094458.3727334.14380672628638785244@wrigleys.postgresql.org>
 <bd50647047caab850dbafe565ef1b1ef8d1027f0.camel@cybertec.at>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="zD44GszxDxRb3li4"
Content-Disposition: inline
In-Reply-To: <bd50647047caab850dbafe565ef1b1ef8d1027f0.camel@cybertec.at>
Archived-At: 
 <https://www.postgresql.org/message-id/ZQjlK-Eh6w6Vo712%40paquier.xyz>
Precedence: bulk


--zD44GszxDxRb3li4
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

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 ba=
ckup
>> is compatible only with current version of database. I can not do baseba=
ckup
>> on v11 and restore that on v15, for example.
>=20
> 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

--zD44GszxDxRb3li4
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmUI5SsACgkQnvQgOdby
QH3z6w/+L1d37q8M1MNlOM0NpHdpH/Vi/N26Wy1TIVc6lqRrSTvuirx8iH4bO1Gj
HB9wKTqWtsFt1bJzQkk734sbT1Wi6TUfuoSBV2jNwRC9fgBQHYt1toFGBrBEvXtv
tFF1dKhCM5AzkhHmAoq6fygOEr7ldRfwmLHEkIHWr5Ps+gnehAPrTqPzzliEHX9X
KrVPDCtmXpme27e8FTuGivsrhLyabpXB3Lx0f7++d8pw3AwFA2YvI3ut3avFisoh
Pv/vzi+PDrY4QPYoZbA+7Y2Enq10D4HcTOzKKN5GTMRJ7wwnfXpNbYceZiw0T99n
OuQxFHAl8XLSNtRVEahlrPjPP9hHpC1+2D2RHP4RpBF6vrFzsyCzfWQK0IgfIAsj
KkGo++Ha85UjJ66XWViK+nz9rO2LjDucWLqVOH/By3s/1xDns7ejFlUUu1o9Guhp
wrbu9s2q1Up+06wG1nQzwSmEkvke1l6PsggAXQKOoirwkKt/rt6QLrsstKFCNGU5
LLGOYkGQwYUSwJwSomN86msTXBL+8NQaROEJWqzmyv4utPYCDE7My/gZBlJpXa0F
VBZaZabCQr8XrbkJ5usGgF4aYst2ti15RveHf8aVBqxabuVy6MJDcHjHiAGiI8Zn
LsbkZRv7qY8rbXRS2FyJXzsDl8gkKxPyf+pqi8+IJdnpf4A9Yg8=
=Yyra
-----END PGP SIGNATURE-----

--zD44GszxDxRb3li4--