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/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
OpenStreetMap: Maps with a human touch