Horton

Thread

Commits

  1. pg_upgrade: Remove some dead code.

  2. Remove pg_upgrade support for upgrading from pre-9.2 servers.

  1. dead code in pg_upgrade

    Nathan Bossart <nathandbossart@gmail.com> — 2025-03-17T17:33:18Z

    While trying to decipher this comment:

		/*
		 * Do the old cluster's per-database directories share a directory
		 * with a new version-specific tablespace?
		 */

I noticed that the condition it's referring to

		if (strlen(old_cluster.tablespace_suffix) == 0)

doesn't appear to have been reachable since support for upgrading from
pre-9.2 was removed in v15 (commit e469f0a).  Before then, this case seems
to have only applied to upgrades from v8.4 or older versions.

I'm planning to commit the attached patch shortly after I double-check that
I'm not missing anything.

-- 
nathan

  2. Re: dead code in pg_upgrade

    Tom Lane <tgl@sss.pgh.pa.us> — 2025-03-17T17:56:49Z

    Nathan Bossart <nathandbossart@gmail.com> writes:
> I noticed that the condition it's referring to
> 		if (strlen(old_cluster.tablespace_suffix) == 0)
> doesn't appear to have been reachable since support for upgrading from
> pre-9.2 was removed in v15 (commit e469f0a).  Before then, this case seems
> to have only applied to upgrades from v8.4 or older versions.

> I'm planning to commit the attached patch shortly after I double-check that
> I'm not missing anything.

+1.  e469f0aaf just removed code that was immediately connected to a
version check; I didn't look too hard for consequent simplifications.
After looking, I concur that tablespace_suffix can never be empty
anymore.  I don't see any other spots checking this condition.

			regards, tom lane

  3. Re: dead code in pg_upgrade

    Nathan Bossart <nathandbossart@gmail.com> — 2025-03-17T18:19:37Z

    On Mon, Mar 17, 2025 at 01:56:49PM -0400, Tom Lane wrote:
> Nathan Bossart <nathandbossart@gmail.com> writes:
>> I noticed that the condition it's referring to
>> 		if (strlen(old_cluster.tablespace_suffix) == 0)
>> doesn't appear to have been reachable since support for upgrading from
>> pre-9.2 was removed in v15 (commit e469f0a).  Before then, this case seems
>> to have only applied to upgrades from v8.4 or older versions.
> 
>> I'm planning to commit the attached patch shortly after I double-check that
>> I'm not missing anything.
> 
> +1.  e469f0aaf just removed code that was immediately connected to a
> version check; I didn't look too hard for consequent simplifications.
> After looking, I concur that tablespace_suffix can never be empty
> anymore.  I don't see any other spots checking this condition.

Committed, thanks for looking.

-- 
nathan