Greetings, This issue was filed with the RPM packager here:
https://redmine.postgresql.org/issues/3710 daryl On Tue, Oct 30, 2018 at 3:30 PM Richard Huesken <[email protected]> wrote: > > Hi, > > My issue has been solved by a tip from Raúl Marín Rodríguez, who pointed out > that geod_polygon_init was introduced in PROJ 4.9.1 and it appears I was > using 4.8.0-4.el7. > This was most likely caused by a packaging issue, I created a ticket for this > issue at: www.postgresql.org (#15472). > > > [root@ol-pg11 ~]# yum list installed | grep proj > proj.x86_64 4.8.0-4.el7 @epel > proj49.x86_64 4.9.3-3.rhel7.1 @pgdg11 > > Indeed there are 2 dependencies in my postgis25_11 package: > > [root@ol-pg11 ~]# yum deplist postgis25_11 > Loaded plugins: langpacks, ulninfo > package: postgis25_11.x86_64 2.5.0-1.rhel7.1 > ... > dependency: libproj.so.0()(64bit) > provider: proj.x86_64 4.8.0-4.el7 > dependency: libproj.so.12()(64bit) > provider: proj49.x86_64 4.9.3-3.rhel7.1 > ... > > postgis-2.5.so seems to be using the one in the /lib64 directory: > > [root@ol-pg11 lib]# ldd postgis-2.5.so > ... > libproj.so.0 => /lib64/libproj.so.0 (0x00007f6792485000) > ... > > The proj4.8 version is located in /lib64 > > [root@ol-pg11 lib]# cd /lib64/ > [root@ol-pg11 lib64]# ls -l libproj.so* > lrwxrwxrwx. 1 root root 16 Oct 29 13:36 libproj.so.0 -> libproj.so.0.7.0 > -rwxr-xr-x. 1 root root 338168 Jan 24 2014 libproj.so.0.7.0 > > Whereas the proj4.9 version is located in /usr/proj49/lib > > [root@ol-pg11 lib64]# find / -name libproj.so.12 > /usr/proj49/lib/libproj.so.12 > > Once the symlink was changed, I was able to create Postgis Extensions in the > Postgres 11 database: > > [root@ol-pg11 lib64]# rm libproj.so.0 > rm: remove symbolic link ‘libproj.so.0’? y > [root@ol-pg11 lib64]# ls -l *proj* > -rwxr-xr-x. 1 root root 338168 Jan 24 2014 libproj.so.0.7.0 > > [root@ol-pg11 lib64]# ln -s /usr/proj49/lib/libproj.so.12 libproj.so.0 > [root@ol-pg11 lib64]# ls -l *proj* > lrwxrwxrwx. 1 root root 29 Oct 30 10:24 libproj.so.0 -> > /usr/proj49/lib/libproj.so.12 > -rwxr-xr-x. 1 root root 338168 Jan 24 2014 libproj.so.0.7.0 > > > PSQL output: > > psql (11.0) > Type "help" for help. > > testgeo=# \dx > List of installed extensions > Name | Version | Schema | Description > ---------+---------+------------+--------------------------------------------------------------------- > plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language > postgis | 2.5.0 | public | PostGIS geometry, geography, and raster > spatial types and functions > > > ---------- Forwarded message --------- > From: Richard Huesken <[email protected]> > Date: ma 29 okt. 2018 om 13:58 > Subject: Problem creating postgis (2.5) extension with postgres 11 > To: <[email protected]> > > > Hi, > > I'm having troubles creating a postgis extension in a postgres11 database > (running on Oracle Enterprise Linux 7). > > As postgres user in the testgeo database I run: > create extension postgis > > > The error is: > SQL Error [XX000]: ERROR: could not load library > "/usr/pgsql-11/lib/postgis-2.5.so": /usr/pgsql-11/lib/postgis-2.5.so: > undefined symbol: geod_polygon_init > ERROR: could not load library "/usr/pgsql-11/lib/postgis-2.5.so": > /usr/pgsql-11/lib/postgis-2.5.so: undefined symbol: geod_polygon_init > ERROR: could not load library "/usr/pgsql-11/lib/postgis-2.5.so": > /usr/pgsql-11/lib/postgis-2.5.so: undefined symbol: geod_polygon_init > > Can somebody please point out what I'm doing wrong ? > > Installed packages: > > [root@ol-pg11 Downloads]# yum list installed | grep postgresql11 > postgresql11.x86_64 11.0-1PGDG.rhel7 @pgdg11 > postgresql11-contrib.x86_64 11.0-1PGDG.rhel7 @pgdg11 > postgresql11-libs.x86_64 11.0-1PGDG.rhel7 @pgdg11 > postgresql11-plpython.x86_64 11.0-1PGDG.rhel7 @pgdg11 > postgresql11-server.x86_64 11.0-1PGDG.rhel7 @pgdg11 > [root@ol-pg11 Downloads]# yum list installed | grep postgis25 > postgis25_11.x86_64 2.5.0-1.rhel7.1 @pgdg11 > postgis25_11-client.x86_64 2.5.0-1.rhel7.1 @pgdg11 > [root@ol-pg11 Downloads]# uname -a > Linux ol-pg11.rihu-ho 4.1.12-124.20.7.el7uek.x86_64 #2 SMP Wed Oct 24 > 14:15:06 PDT 2018 x86_64 x86_64 x86_64 GNU/Linux > > Thanks in advance, > > Richard. > > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
