[postgis-users] [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 <osahon.gis at gmail.com>
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" <adrian.klaver at aklaver.com> 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" <adrian.klaver at aklaver.com
>> <mailto:adrian.klaver at aklaver.com>> 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
>>     adrian.klaver at aklaver.com <mailto:adrian.klaver at aklaver.com>
>>
>>
>>
>>
>>     --
>>     Sent via pgsql-general mailing list (pgsql-general at postgresql.org
>>     <mailto:pgsql-general at postgresql.org>)
>>
>>     To make changes to your subscription:
>>     http://www.postgresql.org/mailpref/pgsql-general
>>     <http://www.postgresql.org/mailpref/pgsql-general>
>>
>>
>>
>
> --
> Adrian Klaver
> adrian.klaver at aklaver.com
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170413/83285a2c/attachment.html>