Re: Error During PostGIS Build From Source on Linux

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(dot)gis(at)gmail(dot)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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>
>>
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org
>> <mailto:pgsql-general(at)postgresql(dot)org>)
>>
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>> <http://www.postgresql.org/mailpref/pgsql-general>
>>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
>