Horton

Re: teach pg_upgrade to handle in-place tablespaces

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Nathan Bossart <nathandbossart@gmail.com>
Cc: Corey Huinker <corey.huinker@gmail.com>, pgsql-hackers@postgresql.org
Date: 2025-07-22T02:17:42Z
Lists: pgsql-hackers 
On Mon, Jul 21, 2025 at 09:06:59PM -0500, Nathan Bossart wrote:
> On Tue, Jul 22, 2025 at 10:37:05AM +0900, Michael Paquier wrote:
>> This would not choke as long as the old cluster is at least at v10,
>> but well why not.
> 
> I'm not sure what you mean.  allow_in_place_tablespaces was added in v15,
> right?

Yes initially, not so these days.  Here are the backpatches across
v10~14:
<16e7a8fd8e97> 2022-07-27 [Alvaro Herrera]  Allow "in place" tablespaces.
<961cab0a5a90> 2022-07-27 [Alvaro Herrera]  Allow "in place" tablespaces.
<7bdbbb87340f> 2022-07-27 [Alvaro Herrera]  Allow "in place" tablespaces.
<258c896418bf> 2022-07-27 [Alvaro Herrera]  Allow "in place" tablespaces.
<ca347f5433ed> 2022-07-27 [Alvaro Herrera]  Allow "in place" tablespaces.
--
Michael

Commits

  1. Teach pg_upgrade to handle in-place tablespaces.