Re: [GENERAL] Error During PostGIS Build From Source on Linux

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: [GENERAL] Error During PostGIS Build From Source on Linux

Osahon Oduware
Hi Adrian,

Thanks for your response. From the solution you provided, does it mean I have to build PostgreSQL first from source, before building GDAL from source?


On Apr 12, 2017 19:24, "Adrian Klaver" <[hidden email]> wrote:
On 04/12/2017 11:11 AM, Rob Sargent wrote:


On 04/12/2017 12:01 PM, Adrian Klaver wrote:
On 04/12/2017 10:14 AM, Osahon Oduware wrote:
Hi All,

I am working on a Linux OS (Centos 6.5). I built GDAL successfully from
source as below:
./configure --prefix=/path/to/gdal
make
make install

Next I built PostgreSQL successfully from source as below:
./configure --prefix=/path/to/pgsql
make
make install

I attempted to configure PostGIS from source as below:
./configure --with-pgconfig=/home/path/to/
pg_config --with-gdalconfig=/path/to/gdal
--with-geosconfig=/path/to/geos-config
--with-xml2config=/path/to/xml2-config --with-projdir=/path/to/proj
--with-gui --with-raster --with-topology

but I get the following error:
configure: error: PostGIS raster requires OGR to be enabled in GDAL. Use
--without-raster to build without raster support.

I sure need the raster support to be enabled in PostGIS. Could anyone
help me out with this.


Use the Postgres YUM repos:

https://www.postgresql.org/download/linux/redhat/

Been  years since I did this but you could (re)build GDAL with OGR as
requested in the error message.

Did a little digging into this and the magic sauce seems to be:

--with-pg=ARG           Include PostgreSQL GDAL/OGR Support (ARG=path to
                          pg_config)


So something like:

./configure --prefix=/path/to/gdal --with-pg=/home/path/to/pg_config

which on my machine got, among other things:

PostgreSQL support:        yes

rjs




--
Adrian Klaver
[hidden email]



--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: [GENERAL] Error During PostGIS Build From Source on Linux

Osahon Oduware
Hi Adrian,

I followed the step you provided and the installation was successful. However, I created a test database and when I try to create a postgis extension in the test database using:
CREATE EXTENSION postgis;

I get the following error:
ERROR: could not load library "/path/to/postgresql/lib/postgis-2.3.so": /path/to/postgresql/lib/postgis-2.3.so: undefined symbol: GEOSClipByRect

Please, do you have any idea what I might be doing wrong?

On Thu, Apr 13, 2017 at 3:40 AM, Osahon Oduware <[hidden email]> wrote:
Hi Adrian,

I will try this and get back to you. Thanks a lot for your help.


On Apr 12, 2017 23:45, "Adrian Klaver" <[hidden email]> wrote:
On 04/12/2017 02:37 PM, Osahon Oduware wrote:
Hi Adrian,

Thanks for your response. From the solution you provided, does it mean I
have to build PostgreSQL first from source, before building GDAL from
source?

Alright did a test run of the build.

I installed the dev packages for GEOS and Proj from packages and I already had the xml2 dev libraries.

I built GDAL using the pg_config from my source install of Postgres.

So when building Postgis after building GDAL  I had to do:

--with-gdalconfig=/path/to/gdal/bin/gdal_config

to get it to see the config file and not throw an error. Then Postgis built.





On Apr 12, 2017 19:24, "Adrian Klaver" <[hidden email]
<mailto:[hidden email]>> wrote:

    On 04/12/2017 11:11 AM, Rob Sargent wrote:



        On 04/12/2017 12:01 PM, Adrian Klaver wrote:

            On 04/12/2017 10:14 AM, Osahon Oduware wrote:

                Hi All,

                I am working on a Linux OS (Centos 6.5). I built GDAL
                successfully from
                source as below:
                ./configure --prefix=/path/to/gdal
                make
                make install

                Next I built PostgreSQL successfully from source as below:
                ./configure --prefix=/path/to/pgsql
                make
                make install

                I attempted to configure PostGIS from source as below:
                ./configure --with-pgconfig=/home/path/to/
                pg_config --with-gdalconfig=/path/to/gdal
                --with-geosconfig=/path/to/geos-config
                --with-xml2config=/path/to/xml2-config
                --with-projdir=/path/to/proj
                --with-gui --with-raster --with-topology

                but I get the following error:
                configure: error: PostGIS raster requires OGR to be
                enabled in GDAL. Use
                --without-raster to build without raster support.

                I sure need the raster support to be enabled in PostGIS.
                Could anyone
                help me out with this.



            Use the Postgres YUM repos:

            https://www.postgresql.org/download/linux/redhat/
            <https://www.postgresql.org/download/linux/redhat/>

        Been  years since I did this but you could (re)build GDAL with
        OGR as
        requested in the error message.


    Did a little digging into this and the magic sauce seems to be:

    --with-pg=ARG           Include PostgreSQL GDAL/OGR Support (ARG=path to
                              pg_config)


    So something like:

    ./configure --prefix=/path/to/gdal --with-pg=/home/path/to/pg_config

    which on my machine got, among other things:

    PostgreSQL support:        yes

        rjs




    --
    Adrian Klaver
    [hidden email] <mailto:[hidden email]>




    --
    Sent via pgsql-general mailing list ([hidden email]
    <mailto:[hidden email]>)

    To make changes to your subscription:
    http://www.postgresql.org/mailpref/pgsql-general
    <http://www.postgresql.org/mailpref/pgsql-general>




--
Adrian Klaver
[hidden email]



_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: [GENERAL] Error During PostGIS Build From Source on Linux

Osahon Oduware
Hi Adrian,

Thanks for your help so far. This is the output of the PostGIS configuration:

-------------- Compiler Info -------------
  C compiler:           gcc -g -O2
  SQL preprocessor:     /usr/bin/cpp -traditional-cpp -w -P

 -------------- Dependencies --------------
  GEOS config:          /home/nagispg/local/geos361/bin/geos-config
  GEOS version:         3.6.1
  GDAL config:          /home/nagispg/local/gdal213/bin/gdal-config
  GDAL version:         2.1.3
  PostgreSQL config:    /home/nagispg/local/pgsql/bin/pg_config
  PostgreSQL version:   PostgreSQL 9.6.2
  PROJ4 version:        49
  Libxml2 config:       /usr/bin/xml2-config
  Libxml2 version:      2.7.6
  JSON-C support:       no
  PCRE support:         no
  PostGIS debug level:  0
  Perl:                 /usr/bin/perl

 --------------- Extensions ---------------
  PostGIS Raster:       enabled
  PostGIS Topology:     enabled
  SFCGAL support:       disabled
  Address Standardizer support:       disabled

 -------- Documentation Generation --------
  xsltproc:             /usr/bin/xsltproc
  xsl style sheets:    
  dblatex:             
  convert:              /usr/bin/convert
  mathml2.dtd:          http://www.w3.org/Math/DTD/mathml2/mathml2.dtd

I had to install a higher version of Proj (4.9.3) that was used to configure PostGIS (I think I read somewhere in the documentation that the version of Proj should be >= 4.6.0). Now, I get the following error when I run CREATE EXTENSION postgis:

ERROR: could not load library postgis-2.3.so: libproj.so.12: cannot open shared object file: No such file or directory

I would be glad if someone could point me to what I am doing wrong and possible solution.


On Thu, Apr 13, 2017 at 3:00 PM, Adrian Klaver <[hidden email]> wrote:
On 04/13/2017 02:46 AM, Osahon Oduware wrote:
Hi Adrian,

I followed the step you provided and the installation was successful.
However, I created a test database and when I try to create a postgis
extension in the test database using:
CREATE EXTENSION postgis;

I get the following error:
ERROR: could not load library "/path/to/postgresql/lib/postgis-2.3.so
<http://postgis-2.3.so>": /path/to/postgresql/lib/postgis-2.3.so
<http://postgis-2.3.so>: undefined symbol: GEOSClipByRect

Please, do you have any idea what I might be doing wrong?


Should have added to my previous post:

If you are going to compile the code, the output at the end of the ./configure process for Postgis is helpful. It helps identify what is going to be included and what is not.

In my case:

PostGIS is now configured for x86_64-pc-linux-gnu

 -------------- Compiler Info -------------
  C compiler:           gcc -g -O2
  SQL preprocessor:     /usr/bin/cpp -traditional-cpp -w -P

 -------------- Dependencies --------------
  GEOS config:          /usr/bin/geos-config
  GEOS version:         3.5.1
  GDAL config:          /home/aklaver/gdal/bin/gdal-config
  GDAL version:         2.1.3
  PostgreSQL config:    /usr/local/pgsql/bin/pg_config
  PostgreSQL version:   PostgreSQL 9.5.6
  PROJ4 version:        49
  Libxml2 config:       /usr/bin/xml2-config
  Libxml2 version:      2.9.4
  JSON-C support:       no
  PCRE support:         yes
  PostGIS debug level:  0
  Perl:                 /usr/bin/perl

 --------------- Extensions ---------------
  PostGIS Raster:       enabled
  PostGIS Topology:     enabled
  SFCGAL support:       disabled
  Address Standardizer support:       enabled

 -------- Documentation Generation --------
  xsltproc:             /usr/bin/xsltproc
  xsl style sheets:
  dblatex:
  convert:              /usr/bin/convert
  mathml2.dtd:          http://www.w3.org/Math/DTD/mathml2/mathml2.dtd

--
Adrian Klaver
[hidden email]


_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: [GENERAL] Error During PostGIS Build From Source on Linux

Osahon Oduware
Hi Adrian,

I installed Proj from source and I can confirm that the file libproj.so.12 is in its lib folder.

I have not been able to confirm if it is linked to postgis-2.3.so as I am away for Easter holiday.

Just in case, how do I do the linking of libproj.so.12 to postgis-2.3.so as I believe this could be the cause of the error. Also, I tried earlier to copy the file to the PostgreSQL lib folder and this time when I try to run "CREATE EXTENSION postgis;" I get the initial error:
ERROR: could not load library "/path/to/postgresql/lib/postgis-2.3.so": /path/to/postgresql/lib/postgis-2.3.so: undefined symbol: GEOSClipByRect

I will be glad if anyone could help with this.

On Apr 13, 2017 18:27, "Adrian Klaver" <[hidden email]> wrote:
On 04/13/2017 07:54 AM, Osahon Oduware wrote:
Hi Adrian,

Thanks for your help so far. This is the output of the PostGIS
configuration:

-------------- Compiler Info -------------
  C compiler:           gcc -g -O2
  SQL preprocessor:     /usr/bin/cpp -traditional-cpp -w -P

 -------------- Dependencies --------------
  GEOS config:          /home/nagispg/local/geos361/bin/geos-config
  GEOS version:         3.6.1
  GDAL config:          /home/nagispg/local/gdal213/bin/gdal-config
  GDAL version:         2.1.3
  PostgreSQL config:    /home/nagispg/local/pgsql/bin/pg_config
  PostgreSQL version:   PostgreSQL 9.6.2
  PROJ4 version:        49
  Libxml2 config:       /usr/bin/xml2-config
  Libxml2 version:      2.7.6
  JSON-C support:       no
  PCRE support:         no
  PostGIS debug level:  0
  Perl:                 /usr/bin/perl

 --------------- Extensions ---------------
  PostGIS Raster:       enabled
  PostGIS Topology:     enabled
  SFCGAL support:       disabled
  Address Standardizer support:       disabled

 -------- Documentation Generation --------
  xsltproc:             /usr/bin/xsltproc
  xsl style sheets:
  dblatex:
  convert:              /usr/bin/convert
  mathml2.dtd:          http://www.w3.org/Math/DTD/mathml2/mathml2.dtd
<http://www.w3.org/Math/DTD/mathml2/mathml2.dtd>

I had to install a *higher version of Proj (4.9.3)* that was used to

configure PostGIS (I think I read somewhere in the documentation that
the version of Proj should be >= 4.6.0). *Now, I get the following error
when I run CREATE EXTENSION postgis:*

How did you install Proj, from a package or source?


*ERROR: could not load library postgis-2.3.so <http://postgis-2.3.so>:
libproj.so.12: cannot open shared object file: No such file or directory*

First find postgis-2.3.so and do:

ldd postgis-2.3.so

It should show something like:

        linux-vdso.so.1 (0x00007ffe3ed8a000)
        libgeos_c.so.1 => /usr/lib64/libgeos_c.so.1 (0x00007f975bd09000)
    ==> libproj.so.9 => /usr/lib64/libproj.so.9 (0x00007f975baaa000)
        libxml2.so.2 => /usr/lib64/libxml2.so.2 (0x00007f975b73f000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f975b442000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f975b09e000)
        libgeos-3.5.1.so => /usr/lib64/libgeos-3.5.1.so (0x00007f975acef000)
        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007f975a966000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f975a74e000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f975a531000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f975a32d000)
        libz.so.1 => /lib64/libz.so.1 (0x00007f975a116000)
        liblzma.so.5 => /usr/lib64/liblzma.so.5 (0x00007f9759eed000)
        /lib64/ld-linux-x86-64.so.2 (0x000055ebafa02000)

That will verify if postgis-2.3.so is linked to libproj.





I would be glad if someone could point me to what I am doing wrong and
possible solution.



--
Adrian Klaver
[hidden email]



_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: [GENERAL] Error During PostGIS Build From Source on Linux

Regina Obe-2

Osahon,

 

That error means you have installed an older version of GEOS in your system and it's picking up the old one instead of the one in your

 

  /home/nagispg/local/geos361/bin/geos-config

 

I suspect that's the same issue with your proj too.

 

I think doing an ldconfig after install of GEOS and proj might fix the issue, but I forget.

 

It's been a while since I've had to compile the extra dependencies even if building PostGIS on Linux.

 

Regarding the whole GDAL thing on windows.

 

I'm the builder of the Windows application Stackbuilder PostGIS bundle and also manage the Windows PostGIS buildbot.

 

As I think someone mentioned, as a policy we don't compile any proprietary extensions into the distributed windows PostGIS bundle.

So that's one reason why Mr. SID is not included and will probably never be included.

 

However, you could convert Mr. SID format to something like OpenJpeg or TIFF using GISInternals GDAL binaries for windows:

 

http://www.gisinternals.com/release.php

 

Last I tried, that one does have Mr. SID support.  Unfortunately you can't swap out his GDAL for the ones we package.

I was hoping I could make that possible at some point, but no free time or enough funding interest to investigate.

 

Thanks,

Regina Obe

PostGIS PSC member

http://postgis.us

http://postgis.net

 



 

From: postgis-users [mailto:[hidden email]] On Behalf Of Osahon Oduware
Sent: Friday, April 14, 2017 3:21 PM
To: Adrian Klaver <[hidden email]>
Cc: [hidden email]; PostGIS Users Discussion <[hidden email]>
Subject: Re: [postgis-users] [GENERAL] Error During PostGIS Build From Source on Linux

 

Hi Adrian,

 

I installed Proj from source and I can confirm that the file libproj.so.12 is in its lib folder.

 

I have not been able to confirm if it is linked to postgis-2.3.so as I am away for Easter holiday.

 

Just in case, how do I do the linking of libproj.so.12 to postgis-2.3.so as I believe this could be the cause of the error. Also, I tried earlier to copy the file to the PostgreSQL lib folder and this time when I try to run "CREATE EXTENSION postgis;" I get the initial error:

ERROR: could not load library "/path/to/postgresql/lib/postgis-2.3.so": /path/to/postgresql/lib/postgis-2.3.so: undefined symbol: GEOSClipByRect

 

I will be glad if anyone could help with this.

 

On Apr 13, 2017 18:27, "Adrian Klaver" <[hidden email]> wrote:

On 04/13/2017 07:54 AM, Osahon Oduware wrote:

Hi Adrian,

Thanks for your help so far. This is the output of the PostGIS
configuration:

-------------- Compiler Info -------------
  C compiler:           gcc -g -O2
  SQL preprocessor:     /usr/bin/cpp -traditional-cpp -w -P

 -------------- Dependencies --------------
  GEOS config:          /home/nagispg/local/geos361/bin/geos-config
  GEOS version:         3.6.1
  GDAL config:          /home/nagispg/local/gdal213/bin/gdal-config
  GDAL version:         2.1.3
  PostgreSQL config:    /home/nagispg/local/pgsql/bin/pg_config
  PostgreSQL version:   PostgreSQL 9.6.2
  PROJ4 version:        49
  Libxml2 config:       /usr/bin/xml2-config
  Libxml2 version:      2.7.6
  JSON-C support:       no
  PCRE support:         no
  PostGIS debug level:  0
  Perl:                 /usr/bin/perl

 --------------- Extensions ---------------
  PostGIS Raster:       enabled
  PostGIS Topology:     enabled
  SFCGAL support:       disabled
  Address Standardizer support:       disabled

 -------- Documentation Generation --------
  xsltproc:             /usr/bin/xsltproc
  xsl style sheets:
  dblatex:
  convert:              /usr/bin/convert
  mathml2.dtd:          http://www.w3.org/Math/DTD/mathml2/mathml2.dtd
<http://www.w3.org/Math/DTD/mathml2/mathml2.dtd>

I had to install a *higher version of Proj (4.9.3)* that was used to


configure PostGIS (I think I read somewhere in the documentation that

the version of Proj should be >= 4.6.0). *Now, I get the following error
when I run CREATE EXTENSION postgis:*


How did you install Proj, from a package or source?


*ERROR: could not load library postgis-2.3.so <http://postgis-2.3.so>:
libproj.so.12: cannot open shared object file: No such file or directory*


First find postgis-2.3.so and do:

ldd postgis-2.3.so

It should show something like:

        linux-vdso.so.1 (0x00007ffe3ed8a000)
        libgeos_c.so.1 => /usr/lib64/libgeos_c.so.1 (0x00007f975bd09000)
    ==> libproj.so.9 => /usr/lib64/libproj.so.9 (0x00007f975baaa000)
        libxml2.so.2 => /usr/lib64/libxml2.so.2 (0x00007f975b73f000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f975b442000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f975b09e000)
        libgeos-3.5.1.so => /usr/lib64/libgeos-3.5.1.so (0x00007f975acef000)
        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007f975a966000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f975a74e000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f975a531000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f975a32d000)
        libz.so.1 => /lib64/libz.so.1 (0x00007f975a116000)
        liblzma.so.5 => /usr/lib64/liblzma.so.5 (0x00007f9759eed000)
        /lib64/ld-linux-x86-64.so.2 (0x000055ebafa02000)

That will verify if postgis-2.3.so is linked to libproj.





I would be glad if someone could point me to what I am doing wrong and
possible solution.

 

--
Adrian Klaver
[hidden email]

 


_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: [GENERAL] Error During PostGIS Build From Source on Linux

Osahon Oduware
Hi Regina,

Thanks a lot for your help. I believe this is where the solution lies. I would give it another try tomorrow when I resume work from the Easter break.

I will update you with my findings.

On Apr 16, 2017 4:52 AM, "Regina Obe" <[hidden email]> wrote:

Osahon,

 

That error means you have installed an older version of GEOS in your system and it's picking up the old one instead of the one in your

 

  /home/nagispg/local/geos361/bin/geos-config

 

I suspect that's the same issue with your proj too.

 

I think doing an ldconfig after install of GEOS and proj might fix the issue, but I forget.

 

It's been a while since I've had to compile the extra dependencies even if building PostGIS on Linux.

 

Regarding the whole GDAL thing on windows.

 

I'm the builder of the Windows application Stackbuilder PostGIS bundle and also manage the Windows PostGIS buildbot.

 

As I think someone mentioned, as a policy we don't compile any proprietary extensions into the distributed windows PostGIS bundle.

So that's one reason why Mr. SID is not included and will probably never be included.

 

However, you could convert Mr. SID format to something like OpenJpeg or TIFF using GISInternals GDAL binaries for windows:

 

http://www.gisinternals.com/release.php

 

Last I tried, that one does have Mr. SID support.  Unfortunately you can't swap out his GDAL for the ones we package.

I was hoping I could make that possible at some point, but no free time or enough funding interest to investigate.

 

Thanks,

Regina Obe

PostGIS PSC member

http://postgis.us

http://postgis.net

 



 

From: postgis-users [mailto:[hidden email]] On Behalf Of Osahon Oduware
Sent: Friday, April 14, 2017 3:21 PM
To: Adrian Klaver <[hidden email]>
Cc: [hidden email]; PostGIS Users Discussion <[hidden email]>
Subject: Re: [postgis-users] [GENERAL] Error During PostGIS Build From Source on Linux

 

Hi Adrian,

 

I installed Proj from source and I can confirm that the file libproj.so.12 is in its lib folder.

 

I have not been able to confirm if it is linked to postgis-2.3.so as I am away for Easter holiday.

 

Just in case, how do I do the linking of libproj.so.12 to postgis-2.3.so as I believe this could be the cause of the error. Also, I tried earlier to copy the file to the PostgreSQL lib folder and this time when I try to run "CREATE EXTENSION postgis;" I get the initial error:

ERROR: could not load library "/path/to/postgresql/lib/postgis-2.3.so": /path/to/postgresql/lib/postgis-2.3.so: undefined symbol: GEOSClipByRect

 

I will be glad if anyone could help with this.

 

On Apr 13, 2017 18:27, "Adrian Klaver" <[hidden email]> wrote:

On 04/13/2017 07:54 AM, Osahon Oduware wrote:

Hi Adrian,

Thanks for your help so far. This is the output of the PostGIS
configuration:

-------------- Compiler Info -------------
  C compiler:           gcc -g -O2
  SQL preprocessor:     /usr/bin/cpp -traditional-cpp -w -P

 -------------- Dependencies --------------
  GEOS config:          /home/nagispg/local/geos361/bin/geos-config
  GEOS version:         3.6.1
  GDAL config:          /home/nagispg/local/gdal213/bin/gdal-config
  GDAL version:         2.1.3
  PostgreSQL config:    /home/nagispg/local/pgsql/bin/pg_config
  PostgreSQL version:   PostgreSQL 9.6.2
  PROJ4 version:        49
  Libxml2 config:       /usr/bin/xml2-config
  Libxml2 version:      2.7.6
  JSON-C support:       no
  PCRE support:         no
  PostGIS debug level:  0
  Perl:                 /usr/bin/perl

 --------------- Extensions ---------------
  PostGIS Raster:       enabled
  PostGIS Topology:     enabled
  SFCGAL support:       disabled
  Address Standardizer support:       disabled

 -------- Documentation Generation --------
  xsltproc:             /usr/bin/xsltproc
  xsl style sheets:
  dblatex:
  convert:              /usr/bin/convert
  mathml2.dtd:          http://www.w3.org/Math/DTD/mathml2/mathml2.dtd
<http://www.w3.org/Math/DTD/mathml2/mathml2.dtd>

I had to install a *higher version of Proj (4.9.3)* that was used to


configure PostGIS (I think I read somewhere in the documentation that

the version of Proj should be >= 4.6.0). *Now, I get the following error
when I run CREATE EXTENSION postgis:*


How did you install Proj, from a package or source?


*ERROR: could not load library postgis-2.3.so <http://postgis-2.3.so>:
libproj.so.12: cannot open shared object file: No such file or directory*


First find postgis-2.3.so and do:

ldd postgis-2.3.so

It should show something like:

        linux-vdso.so.1 (0x00007ffe3ed8a000)
        libgeos_c.so.1 => /usr/lib64/libgeos_c.so.1 (0x00007f975bd09000)
    ==> libproj.so.9 => /usr/lib64/libproj.so.9 (0x00007f975baaa000)
        libxml2.so.2 => /usr/lib64/libxml2.so.2 (0x00007f975b73f000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f975b442000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f975b09e000)
        libgeos-3.5.1.so => /usr/lib64/libgeos-3.5.1.so (0x00007f975acef000)
        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007f975a966000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f975a74e000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f975a531000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f975a32d000)
        libz.so.1 => /lib64/libz.so.1 (0x00007f975a116000)
        liblzma.so.5 => /usr/lib64/liblzma.so.5 (0x00007f9759eed000)
        /lib64/ld-linux-x86-64.so.2 (0x000055ebafa02000)

That will verify if postgis-2.3.so is linked to libproj.





I would be glad if someone could point me to what I am doing wrong and
possible solution.

 

--
Adrian Klaver
[hidden email]

 


_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: [GENERAL] Error During PostGIS Build From Source on Linux

Osahon Oduware
In reply to this post by Regina Obe-2
Hi Regina,

This suggestion helped to resolve the problem. Thanks a lot for your help.

On Sun, Apr 16, 2017 at 4:52 AM, Regina Obe <[hidden email]> wrote:

Osahon,

 

That error means you have installed an older version of GEOS in your system and it's picking up the old one instead of the one in your

 

  /home/nagispg/local/geos361/bin/geos-config

 

I suspect that's the same issue with your proj too.

 

I think doing an ldconfig after install of GEOS and proj might fix the issue, but I forget.

 

It's been a while since I've had to compile the extra dependencies even if building PostGIS on Linux.

 

Regarding the whole GDAL thing on windows.

 

I'm the builder of the Windows application Stackbuilder PostGIS bundle and also manage the Windows PostGIS buildbot.

 

As I think someone mentioned, as a policy we don't compile any proprietary extensions into the distributed windows PostGIS bundle.

So that's one reason why Mr. SID is not included and will probably never be included.

 

However, you could convert Mr. SID format to something like OpenJpeg or TIFF using GISInternals GDAL binaries for windows:

 

http://www.gisinternals.com/release.php

 

Last I tried, that one does have Mr. SID support.  Unfortunately you can't swap out his GDAL for the ones we package.

I was hoping I could make that possible at some point, but no free time or enough funding interest to investigate.

 

Thanks,

Regina Obe

PostGIS PSC member

http://postgis.us

http://postgis.net

 



 

From: postgis-users [mailto:[hidden email]] On Behalf Of Osahon Oduware
Sent: Friday, April 14, 2017 3:21 PM
To: Adrian Klaver <[hidden email]>
Cc: [hidden email]; PostGIS Users Discussion <[hidden email]>
Subject: Re: [postgis-users] [GENERAL] Error During PostGIS Build From Source on Linux

 

Hi Adrian,

 

I installed Proj from source and I can confirm that the file libproj.so.12 is in its lib folder.

 

I have not been able to confirm if it is linked to postgis-2.3.so as I am away for Easter holiday.

 

Just in case, how do I do the linking of libproj.so.12 to postgis-2.3.so as I believe this could be the cause of the error. Also, I tried earlier to copy the file to the PostgreSQL lib folder and this time when I try to run "CREATE EXTENSION postgis;" I get the initial error:

ERROR: could not load library "/path/to/postgresql/lib/postgis-2.3.so": /path/to/postgresql/lib/postgis-2.3.so: undefined symbol: GEOSClipByRect

 

I will be glad if anyone could help with this.

 

On Apr 13, 2017 18:27, "Adrian Klaver" <[hidden email]> wrote:

On 04/13/2017 07:54 AM, Osahon Oduware wrote:

Hi Adrian,

Thanks for your help so far. This is the output of the PostGIS
configuration:

-------------- Compiler Info -------------
  C compiler:           gcc -g -O2
  SQL preprocessor:     /usr/bin/cpp -traditional-cpp -w -P

 -------------- Dependencies --------------
  GEOS config:          /home/nagispg/local/geos361/bin/geos-config
  GEOS version:         3.6.1
  GDAL config:          /home/nagispg/local/gdal213/bin/gdal-config
  GDAL version:         2.1.3
  PostgreSQL config:    /home/nagispg/local/pgsql/bin/pg_config
  PostgreSQL version:   PostgreSQL 9.6.2
  PROJ4 version:        49
  Libxml2 config:       /usr/bin/xml2-config
  Libxml2 version:      2.7.6
  JSON-C support:       no
  PCRE support:         no
  PostGIS debug level:  0
  Perl:                 /usr/bin/perl

 --------------- Extensions ---------------
  PostGIS Raster:       enabled
  PostGIS Topology:     enabled
  SFCGAL support:       disabled
  Address Standardizer support:       disabled

 -------- Documentation Generation --------
  xsltproc:             /usr/bin/xsltproc
  xsl style sheets:
  dblatex:
  convert:              /usr/bin/convert
  mathml2.dtd:          http://www.w3.org/Math/DTD/mathml2/mathml2.dtd
<http://www.w3.org/Math/DTD/mathml2/mathml2.dtd>

I had to install a *higher version of Proj (4.9.3)* that was used to


configure PostGIS (I think I read somewhere in the documentation that

the version of Proj should be >= 4.6.0). *Now, I get the following error
when I run CREATE EXTENSION postgis:*


How did you install Proj, from a package or source?


*ERROR: could not load library postgis-2.3.so <http://postgis-2.3.so>:
libproj.so.12: cannot open shared object file: No such file or directory*


First find postgis-2.3.so and do:

ldd postgis-2.3.so

It should show something like:

        linux-vdso.so.1 (0x00007ffe3ed8a000)
        libgeos_c.so.1 => /usr/lib64/libgeos_c.so.1 (0x00007f975bd09000)
    ==> libproj.so.9 => /usr/lib64/libproj.so.9 (0x00007f975baaa000)
        libxml2.so.2 => /usr/lib64/libxml2.so.2 (0x00007f975b73f000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f975b442000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f975b09e000)
        libgeos-3.5.1.so => /usr/lib64/libgeos-3.5.1.so (0x00007f975acef000)
        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007f975a966000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f975a74e000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f975a531000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f975a32d000)
        libz.so.1 => /lib64/libz.so.1 (0x00007f975a116000)
        liblzma.so.5 => /usr/lib64/liblzma.so.5 (0x00007f9759eed000)
        /lib64/ld-linux-x86-64.so.2 (0x000055ebafa02000)

That will verify if postgis-2.3.so is linked to libproj.





I would be glad if someone could point me to what I am doing wrong and
possible solution.

 

--
Adrian Klaver
[hidden email]

 


_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: [GENERAL] Error During PostGIS Build From Source on Linux

Osahon Oduware
In reply to this post by Osahon Oduware
Hi Regina,

This suggestion helped to resolve the problem. Thanks a lot for your help.

On Mon, Apr 17, 2017 at 11:13 AM, Osahon Oduware <[hidden email]> wrote:
Hi Regina,

Thanks a lot for your help. I believe this is where the solution lies. I would give it another try tomorrow when I resume work from the Easter break.

I will update you with my findings.

On Apr 16, 2017 4:52 AM, "Regina Obe" <[hidden email]> wrote:

Osahon,

 

That error means you have installed an older version of GEOS in your system and it's picking up the old one instead of the one in your

 

  /home/nagispg/local/geos361/bin/geos-config

 

I suspect that's the same issue with your proj too.

 

I think doing an ldconfig after install of GEOS and proj might fix the issue, but I forget.

 

It's been a while since I've had to compile the extra dependencies even if building PostGIS on Linux.

 

Regarding the whole GDAL thing on windows.

 

I'm the builder of the Windows application Stackbuilder PostGIS bundle and also manage the Windows PostGIS buildbot.

 

As I think someone mentioned, as a policy we don't compile any proprietary extensions into the distributed windows PostGIS bundle.

So that's one reason why Mr. SID is not included and will probably never be included.

 

However, you could convert Mr. SID format to something like OpenJpeg or TIFF using GISInternals GDAL binaries for windows:

 

http://www.gisinternals.com/release.php

 

Last I tried, that one does have Mr. SID support.  Unfortunately you can't swap out his GDAL for the ones we package.

I was hoping I could make that possible at some point, but no free time or enough funding interest to investigate.

 

Thanks,

Regina Obe

PostGIS PSC member

http://postgis.us

http://postgis.net

 



 

From: postgis-users [mailto:[hidden email]] On Behalf Of Osahon Oduware
Sent: Friday, April 14, 2017 3:21 PM
To: Adrian Klaver <[hidden email]>
Cc: [hidden email]; PostGIS Users Discussion <[hidden email]>
Subject: Re: [postgis-users] [GENERAL] Error During PostGIS Build From Source on Linux

 

Hi Adrian,

 

I installed Proj from source and I can confirm that the file libproj.so.12 is in its lib folder.

 

I have not been able to confirm if it is linked to postgis-2.3.so as I am away for Easter holiday.

 

Just in case, how do I do the linking of libproj.so.12 to postgis-2.3.so as I believe this could be the cause of the error. Also, I tried earlier to copy the file to the PostgreSQL lib folder and this time when I try to run "CREATE EXTENSION postgis;" I get the initial error:

ERROR: could not load library "/path/to/postgresql/lib/postgis-2.3.so": /path/to/postgresql/lib/postgis-2.3.so: undefined symbol: GEOSClipByRect

 

I will be glad if anyone could help with this.

 

On Apr 13, 2017 18:27, "Adrian Klaver" <[hidden email]> wrote:

On 04/13/2017 07:54 AM, Osahon Oduware wrote:

Hi Adrian,

Thanks for your help so far. This is the output of the PostGIS
configuration:

-------------- Compiler Info -------------
  C compiler:           gcc -g -O2
  SQL preprocessor:     /usr/bin/cpp -traditional-cpp -w -P

 -------------- Dependencies --------------
  GEOS config:          /home/nagispg/local/geos361/bin/geos-config
  GEOS version:         3.6.1
  GDAL config:          /home/nagispg/local/gdal213/bin/gdal-config
  GDAL version:         2.1.3
  PostgreSQL config:    /home/nagispg/local/pgsql/bin/pg_config
  PostgreSQL version:   PostgreSQL 9.6.2
  PROJ4 version:        49
  Libxml2 config:       /usr/bin/xml2-config
  Libxml2 version:      2.7.6
  JSON-C support:       no
  PCRE support:         no
  PostGIS debug level:  0
  Perl:                 /usr/bin/perl

 --------------- Extensions ---------------
  PostGIS Raster:       enabled
  PostGIS Topology:     enabled
  SFCGAL support:       disabled
  Address Standardizer support:       disabled

 -------- Documentation Generation --------
  xsltproc:             /usr/bin/xsltproc
  xsl style sheets:
  dblatex:
  convert:              /usr/bin/convert
  mathml2.dtd:          http://www.w3.org/Math/DTD/mathml2/mathml2.dtd
<http://www.w3.org/Math/DTD/mathml2/mathml2.dtd>

I had to install a *higher version of Proj (4.9.3)* that was used to


configure PostGIS (I think I read somewhere in the documentation that

the version of Proj should be >= 4.6.0). *Now, I get the following error
when I run CREATE EXTENSION postgis:*


How did you install Proj, from a package or source?


*ERROR: could not load library postgis-2.3.so <http://postgis-2.3.so>:
libproj.so.12: cannot open shared object file: No such file or directory*


First find postgis-2.3.so and do:

ldd postgis-2.3.so

It should show something like:

        linux-vdso.so.1 (0x00007ffe3ed8a000)
        libgeos_c.so.1 => /usr/lib64/libgeos_c.so.1 (0x00007f975bd09000)
    ==> libproj.so.9 => /usr/lib64/libproj.so.9 (0x00007f975baaa000)
        libxml2.so.2 => /usr/lib64/libxml2.so.2 (0x00007f975b73f000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f975b442000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f975b09e000)
        libgeos-3.5.1.so => /usr/lib64/libgeos-3.5.1.so (0x00007f975acef000)
        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007f975a966000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f975a74e000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f975a531000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f975a32d000)
        libz.so.1 => /lib64/libz.so.1 (0x00007f975a116000)
        liblzma.so.5 => /usr/lib64/liblzma.so.5 (0x00007f9759eed000)
        /lib64/ld-linux-x86-64.so.2 (0x000055ebafa02000)

That will verify if postgis-2.3.so is linked to libproj.





I would be glad if someone could point me to what I am doing wrong and
possible solution.

 

--
Adrian Klaver
[hidden email]

 


_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users