<div dir="ltr"><div dir="ltr"><div dir="ltr"><div>Hi,</div><div><br></div><div>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.</div><div>This was most likely caused by a packaging issue, I created a ticket for this issue at: <a href="http://www.postgresql.org">www.postgresql.org</a> (#15472).</div><div><br></div><div><br></div><div>[root@ol-pg11 ~]# yum list installed | grep proj</div><div>proj.x86_64 4.8.0-4.el7 @epel</div><div>proj49.x86_64 4.9.3-3.rhel7.1 @pgdg11</div><div><br></div><div>Indeed there are 2 dependencies in my postgis25_11 package:</div><div><br></div><div>[root@ol-pg11 ~]# yum deplist postgis25_11</div><div>Loaded plugins: langpacks, ulninfo</div><div>package: postgis25_11.x86_64 2.5.0-1.rhel7.1</div><div>...</div><div> dependency: libproj.so.0()(64bit)</div><div> provider: proj.x86_64 4.8.0-4.el7</div><div> dependency: libproj.so.12()(64bit)</div><div> provider: proj49.x86_64 4.9.3-3.rhel7.1</div><div>...</div><div><br></div><div><a href="http://postgis-2.5.so">postgis-2.5.so</a> seems to be using the one in the /lib64 directory:</div><div><br></div><div>[root@ol-pg11 lib]# ldd <a href="http://postgis-2.5.so">postgis-2.5.so</a></div><div>...</div><div> libproj.so.0 => /lib64/libproj.so.0 (0x00007f6792485000)</div><div>...</div><div><br></div><div>The proj4.8 version is located in /lib64</div><div><br></div><div>[root@ol-pg11 lib]# cd /lib64/</div><div>[root@ol-pg11 lib64]# ls -l libproj.so*</div><div>lrwxrwxrwx. 1 root root 16 Oct 29 13:36 libproj.so.0 -> libproj.so.0.7.0</div><div>-rwxr-xr-x. 1 root root 338168 Jan 24 2014 libproj.so.0.7.0</div><div><br></div><div>Whereas the proj4.9 version is located in /usr/proj49/lib</div><div><br></div><div>[root@ol-pg11 lib64]# find / -name libproj.so.12</div><div>/usr/proj49/lib/libproj.so.12</div><div><br></div><div>Once the symlink was changed, I was able to create Postgis Extensions in the Postgres 11 database:</div><div><br></div><div>[root@ol-pg11 lib64]# rm libproj.so.0</div><div>rm: remove symbolic link ‘libproj.so.0’? y</div><div>[root@ol-pg11 lib64]# ls -l *proj*</div><div>-rwxr-xr-x. 1 root root 338168 Jan 24 2014 libproj.so.0.7.0</div><div><br></div><div>[root@ol-pg11 lib64]# ln -s /usr/proj49/lib/libproj.so.12 libproj.so.0</div><div>[root@ol-pg11 lib64]# ls -l *proj*</div><div>lrwxrwxrwx. 1 root root 29 Oct 30 10:24 libproj.so.0 -> /usr/proj49/lib/libproj.so.12</div><div>-rwxr-xr-x. 1 root root 338168 Jan 24 2014 libproj.so.0.7.0</div><div><br></div><div><br></div><div>PSQL output:</div><div><br></div><div>psql (11.0)</div><div>Type "help" for help.</div><div><br></div><div>testgeo=# \dx</div><div> List of installed extensions</div><div> Name | Version | Schema | Description</div><div>---------+---------+------------+---------------------------------------------------------------------</div><div> plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language</div><div> postgis | 2.5.0 | public | PostGIS geometry, geography, and raster spatial types and functions</div><div><br></div><br><div class="gmail_quote"><div dir="ltr">---------- Forwarded message ---------<br>From: <strong class="gmail_sendername" dir="auto">Richard Huesken</strong> <span dir="ltr"><<a href="mailto:richard.huesken@gmail.com">richard.huesken@gmail.com</a>></span><br>Date: ma 29 okt. 2018 om 13:58<br>Subject: Problem creating postgis (2.5) extension with postgres 11<br>To: <<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br></div><br><br><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Hi,<div><br></div><div>I'm having troubles creating a postgis extension in a postgres11 database (running on Oracle Enterprise Linux 7).</div><div><br></div><div><div>As postgres user in the testgeo database I run: </div><div>create extension postgis<br></div><div><br class="gmail-m_7034893698709054760gmail-Apple-interchange-newline"></div></div><div><br></div><div>The error is:</div><div>SQL Error [XX000]: ERROR: could not load library "/usr/pgsql-11/lib/<a href="http://postgis-2.5.so" target="_blank">postgis-2.5.so</a>": /usr/pgsql-11/lib/<a href="http://postgis-2.5.so" target="_blank">postgis-2.5.so</a>: undefined symbol: geod_polygon_init<br></div><div><div> ERROR: could not load library "/usr/pgsql-11/lib/<a href="http://postgis-2.5.so" target="_blank">postgis-2.5.so</a>": /usr/pgsql-11/lib/<a href="http://postgis-2.5.so" target="_blank">postgis-2.5.so</a>: undefined symbol: geod_polygon_init</div><div> ERROR: could not load library "/usr/pgsql-11/lib/<a href="http://postgis-2.5.so" target="_blank">postgis-2.5.so</a>": /usr/pgsql-11/lib/<a href="http://postgis-2.5.so" target="_blank">postgis-2.5.so</a>: undefined symbol: geod_polygon_init</div></div><div><br></div><div>Can somebody please point out what I'm doing wrong ?</div><div><br></div><div>Installed packages:</div><div><br></div><div><div>[root@ol-pg11 Downloads]# yum list installed | grep postgresql11</div><div>postgresql11.x86_64 11.0-1PGDG.rhel7 @pgdg11</div><div>postgresql11-contrib.x86_64 11.0-1PGDG.rhel7 @pgdg11</div><div>postgresql11-libs.x86_64 11.0-1PGDG.rhel7 @pgdg11</div><div>postgresql11-plpython.x86_64 11.0-1PGDG.rhel7 @pgdg11</div><div>postgresql11-server.x86_64 11.0-1PGDG.rhel7 @pgdg11</div><div>[root@ol-pg11 Downloads]# yum list installed | grep postgis25</div><div>postgis25_11.x86_64 2.5.0-1.rhel7.1 @pgdg11</div><div>postgis25_11-client.x86_64 2.5.0-1.rhel7.1 @pgdg11</div><div>[root@ol-pg11 Downloads]# uname -a</div><div>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</div></div><div><br></div><div>Thanks in advance,</div><div><br></div><div>Richard.</div><div><br></div></div></div></div></div>
</div></div></div></div>