pg_upgrade fails due to lack of dependencies.

[Laurenz Albe]

On Wed, 2025-07-02 at 11:12 -0400, Regina Obe wrote:
> Okay so I see no point in adding this dependency as it still requires people to
> do work arounds with loading the data and people can already fuss with pg_depend
> if they have superuser rights.

You said above that your users are usually smart enough to deal with problems
like that.  In that case, your users must be way smarter than the average
PostgreSQL user.

The idea of manually fiddling with pg_depend scares even me.

The place where I'd look if I wanted to upgrade my spatial database would be
https://postgis.net/docs/manual-3.5/postgis_administration.html#upgrading

Perhaps it would be a good idea to mention there that an upgrade using
pg_upgrade is likely to fail if you are using functions that rely on SRID
definitions in indexes, generated columns or partitioning keys.

Yours,
Laurenz Albe