pg_upgrade fails when upgrading from v14 to v16
Summary pg_upgrade failed when upgrading a PostgreSQL server from v14 to v16 due to incompatible extensions (pgvector and hydra) causing schema restoration issues during the upgrade process. Root Cause The root cause was inconsistent schema definitions between PostgreSQL v14 and v16 for the installed extensions (pgvector and hydra). Specifically, the attislocal attribute in the pg_attribute … Read more