Thread: Heads up: Potential PostGIS breakage is coming
Hi, I am about to push PostGIS 2.4.2-2 packages to 10-testing repos. Unlike the other packages, the new packages will depend on proj49 (Proj 4.9) and geos36 (GeOS 3.6) packages, which installs to non-standard directories (/usr/proj49 and /usr/geos36, respectively), so won't conflict with the OS packages, but will use recent versions of Proj and GeOS. With this change, we can introduce GeOS 3.7 support to our repo, when it is released. I read some reports about proj 4.8 reporting incorrect results, that triggered this package process. So, I will be happy if someone can test by enabling PG 10 testing repository, and see if things are broken or not. Thanks! Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
On Wed, Nov 22, 2017 at 7:59 AM Devrim Gündüz wrote:
>
> Hi,
>
> I am about to push PostGIS 2.4.2-2 packages to 10-testing repos. Unlike the
> other packages, the new packages will depend on proj49 (Proj 4.9) and
> geos36
> (GeOS 3.6) packages, which installs to non-standard directories
> (/usr/proj49
> and /usr/geos36, respectively), so won't conflict with the OS packages, but
> will use recent versions of Proj and GeOS. With this change, we can
> introduce
> GeOS 3.7 support to our repo, when it is released.
>
> I read some reports about proj 4.8 reporting incorrect results, that
> triggered
> this package process.
>
> So, I will be happy if someone can test by enabling PG 10 testing
> repository,
> and see if things are broken or not.
>
>
I think postgis is not dynamically linking properly to proj. It finds the
path fine when compiling, though. Perhaps it, like libproj49 itself in
relation to geos36, requires some ldconfig files.
Hi Daniel,
Thank you for the feedback!
Can you please update the packages? I pushed a fix for this last week.
Regards, Devrim
On 27 November 2017 22:04:58 GMT+00:00, Daniel Farina wrote:
>On Wed, Nov 22, 2017 at 7:59 AM Devrim Gündüz
>wrote:
>
>>
>> Hi,
>>
>> I am about to push PostGIS 2.4.2-2 packages to 10-testing repos.
>Unlike the
>> other packages, the new packages will depend on proj49 (Proj 4.9) and
>> geos36
>> (GeOS 3.6) packages, which installs to non-standard directories
>> (/usr/proj49
>> and /usr/geos36, respectively), so won't conflict with the OS
>packages, but
>> will use recent versions of Proj and GeOS. With this change, we can
>> introduce
>> GeOS 3.7 support to our repo, when it is released.
>>
>> I read some reports about proj 4.8 reporting incorrect results, that
>> triggered
>> this package process.
>>
>> So, I will be happy if someone can test by enabling PG 10 testing
>> repository,
>> and see if things are broken or not.
>>
>>
>I think postgis is not dynamically linking properly to proj. It finds
>the
>path fine when compiling, though. Perhaps it, like libproj49 itself in
>relation to geos36, requires some ldconfig files.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
On Mon, Nov 27, 2017 at 2:08 PM Devrim Gündüz wrote:
> Hi Daniel,
>
> Thank you for the feedback!
>
> Can you please update the packages? I pushed a fix for this last week.
>
> Regards, Devrim
>
I saw that with regard to proj and geos, and I'm updated, but I think
postgis itself needs similar treatment.
=# create extension postgis;
ERROR: could not load library "/usr/pgsql-10/lib/postgis-2.4.so":
libproj.so.12: cannot open shared object file: No such file or directory
=# \q
$ find /usr/ -name 'libproj.so.12'
/usr/proj49/lib/libproj.so.12
Hi Daniel, On Mon, 2017-11-27 at 22:11 +0000, Daniel Farina wrote: > I saw that with regard to proj and geos, and I'm updated, but I think > postgis itself needs similar treatment. > > =# create extension postgis; > ERROR: could not load library "/usr/pgsql-10/lib/postgis-2.4.so": > libproj.so.12: cannot open shared object file: No such file or directory > =# \q > $ find /usr/ -name 'libproj.so.12' > /usr/proj49/lib/libproj.so.12 Arrgh, /etc/ld.so.conf.d/proj49-pgdg-libs.conf is broken :-( I accidentally added geos related lines there :( Sorry about that. I did not catch this before, because I also had OS-supplied proj package :( Pushed 4.9.3-3 to repos, they will be available in next 20 mins. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR