Compiling PostGIS against PostgreSQL 8.4

[Jorge Arévalo]

Hello,

I've recently updated from Postgresql 8.3 to 8.4, due to an update on
Ubuntu (from 9.04 to 9.10). When trying to create new spatial
databases, by executing postgis.sql, I get an error because
LWGEOM_samebox is not found in library object. The problem is
postgis.sql is looking for this function in the old library object,
this is /usr/lib/postgresql/8.3/lib/postgis-1.5.so, instead on
/usr/lib/postgresql/8.4/lib/postgis-1.5.so

When I run ./configure, I get 8.4 as PostgreSQL version, but I don't
know how to avoid the linking against the old library object.

How should I do it?

Thanks in advance!

Best regards,
Jorge
_______________________________________________
postgis-devel mailing list
postgis-devel@...
http://postgis.refractions.net/mailman/listinfo/postgis-devel

[Mateusz Loskot]

Jorge Arévalo wrote:

> Hello,
>
> I've recently updated from Postgresql 8.3 to 8.4, due to an update on
> Ubuntu (from 9.04 to 9.10). When trying to create new spatial
> databases, by executing postgis.sql, I get an error because
> LWGEOM_samebox is not found in library object. The problem is
> postgis.sql is looking for this function in the old library object,
> this is /usr/lib/postgresql/8.3/lib/postgis-1.5.so, instead on
> /usr/lib/postgresql/8.4/lib/postgis-1.5.so
>
> When I run ./configure, I get 8.4 as PostgreSQL version, but I don't
> know how to avoid the linking against the old library object.
>
> How should I do it?

Check if PostgreSQL 8.3 related packages (including the one that
installs pg_config) have been removed?
I found that after upgrade form 9.04 to 9.10 I had to do manual
cleanup to get rid of of all packages related to PostgreSQL 8.3

Best regards,
--
Mateusz Loskot, http://mateusz.loskot.net
Charter Member of OSGeo, http://osgeo.org
_______________________________________________
postgis-devel mailing list
postgis-devel@...
http://postgis.refractions.net/mailman/listinfo/postgis-devel

[Jorge Arévalo]

On Sat, Nov 7, 2009 at 8:33 PM, Mateusz Loskot <mateusz@...> wrote:

> Jorge Arévalo wrote:
>> Hello,
>>
>> I've recently updated from Postgresql 8.3 to 8.4, due to an update on
>> Ubuntu (from 9.04 to 9.10). When trying to create new spatial
>> databases, by executing postgis.sql, I get an error because
>> LWGEOM_samebox is not found in library object. The problem is
>> postgis.sql is looking for this function in the old library object,
>> this is /usr/lib/postgresql/8.3/lib/postgis-1.5.so, instead on
>> /usr/lib/postgresql/8.4/lib/postgis-1.5.so
>>
>> When I run ./configure, I get 8.4 as PostgreSQL version, but I don't
>> know how to avoid the linking against the old library object.
>>
>> How should I do it?
>
> Check if PostgreSQL 8.3 related packages (including the one that
> installs pg_config) have been removed?
> I found that after upgrade form 9.04 to 9.10 I had to do manual
> cleanup to get rid of of all packages related to PostgreSQL 8.3
>
> Best regards,
> --
> Mateusz Loskot, http://mateusz.loskot.net
> Charter Member of OSGeo, http://osgeo.org
> _______________________________________________
> postgis-devel mailing list
> postgis-devel@...
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>

Hello,

I've just solved the problem by upgrading the old 8.3 cluster to the
new version (via pg_dropcluster and pg_upgradecluster), deleting the
postgresql-8.3 and postgresql-client-8.3 packages and re-building
PostGIS.

Thanks for your suggestion Mateusz!

Best regards,
Jorge
_______________________________________________
postgis-devel mailing list
postgis-devel@...
http://postgis.refractions.net/mailman/listinfo/postgis-devel