pg_upgrade fails due to lack of dependencies.

[Paul Ramsey]

> On Jul 2, 2025, at 9:19 AM, Regina Obe <lr at pcorp.us> wrote:
> 
> I even like it less if it still requires shuffling your pg_upgrade to restore data in the right order.

This is the one that gets me. The dependency only buys us getting the DDL created in the correct order, but it doesn’t guarantee we avoid “missing SRID” issues, so the upgrade process is going to be fraught regardless. 

Hm, I kind of wish I had a reproducer in hand I could step through and at least see what is triggering the SRID issue in geometry. Because like Regina says, for modern PostGIS on modern Proj, the SRS lookup shouldn’t hit the spatial_ref_sys table at all, for the 99.999% of users who just use an SRS that exists in the EPSG database. So why are we hitting a code line that is causing that “spatial_ref_sys is missing” error message, which I would only expect to happen if something falls back to a lookup for an unknown SRID.

P.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20250702/7dfc0cd7/attachment.htm>