F27 to F28 - Postgresql upgrade fails

[Clifford Snow <clifford@xxxxxxxxxxxxxx>]

I just upgraded from Fedora 27 to 28. Everything working except the upgrade from Postgresql 9.6 to 10

Searching for help led me to manually add postgis-2.3.so and rtpostgis-2.3.so to /usr/lib64/pgsql/ and /usr/lib64/pgsql/postgresql-9.6/lib/

Then when postgresql-setup --upgrade is run a fatal error is reported for missing libraries.

the file loadable_libraries.txt contains

could not load library "$libdir/postgis-2.3": ERROR:  could not load library "/usr/lib64/pgsql/postgis-2.3.so": /usr/lib64/pgsql/postgis-2.3.so: undefined symbol: Float8GetDatum

could not load library "$libdir/rtpostgis-2.3": ERROR:  could not load library "/usr/lib64/pgsql/rtpostgis-2.3.so": /usr/lib64/pgsql/rtpostgis-2.3.so: undefined symbol: DatumGetFloat8

could not load library "$libdir/postgis_topology-2.3": ERROR:  could not load library "/usr/lib64/pgsql/postgis_topology-2.3.so": /usr/lib64/pgsql/postgis_topology-2.3.so: undefined sy

mbol: DatumGetFloat8

could not load library "$libdir/address_standardizer-2.3": ERROR:  could not access file "$libdir/address_standardizer-2.3": No such file or directory

Any suggestions to solve this without having to manually restore from my dump?

Thanks in advance,

Clifford

--

@osm_seattle

osm_seattle.snowandsnow.us

OpenStreetMap: Maps with a human touch

_______________________________________________
users mailing list -- users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe send an email to users-leave@xxxxxxxxxxxxxxxxxxxxxxx
Fedora Code of Conduct: https://getfedora.org/code-of-conduct.html
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives: https://lists.fedoraproject.org/archives/list/users@xxxxxxxxxxxxxxxxxxxxxxx/message/5GEUPDWYQZBPRDREV3J754YXC3OWTO55/