On recent upgrade to Fedora Workstation 38, looking to get PostgreSQL installed with postGIS:
sudo dnf install postgresql-server postgresql-contrib postgis pgadmin4
The above installs PostgreSQL 15.1 fine with all install requests using just the Fedora repo.
I can configure PostgreSQL, start the service, and start creating/looking at dbs with pgAdmin4.
However, if I run the
CREATE EXTENSION postgis; command in an SQL query against a new db then the postGIS extension can’t be created due to a postGIS library error:
ERROR: could not load library “/usr/lib64/pgsql/postgis-3.so”: /usr/lib64/pgsql/postgis-3.so: undefined symbol: GEOSConcaveHullOfPolygons
SQL state: 58P01
sudo dnf remove postgis and manually installing a postgis RPM from postgresql.org, but unfortunately those RPM versions have quite a few other dependencies that are not installed. I also tried ditching the Fedora repo version of the PostgreSQL apps then going with the PostgreSQL versions instead:
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/F-37-x86_64/pgdg-fedora-repo-latest.noarch.rpm sudo dnf install -y postgresql15-server postgresql15-contrib
Those actually run fine on Fedora 38 too, but don’t recognize that the Fedora repo version of postgis is installed. Likely this is due to using a slightly different directory structure.
I’ve reverted to the official Fedora versions of PostgreSQL, although I do think the postgresql.org versions are more advantageous because I can stick with a major release (v15) until I want to move on to the next one (v16.)
If anyone can help point me to getting a version of postGIS installed and working on Fedora Workstation 38 with either the Fedora repo version of PostgreSQL or the postgresql.org version, that’d be greatly appreciated.
Respectfully, (I really appreciate all the work folks put in maintaining these repositories,) it also seems to me that there is an issue/bug with the version of postGIS provided in the Fedora 38 repositories not being compatible with the version of PostgreSQL in the same repositories, so hopefully sharing this feedback may be helpful.