[postgis-devel] [postgis-users] SFCGAL : trouble installing

[Rémi Cura]

[SOLVED]

I had to put permissive rights on the libSFCGAL.* file in "/usr/local/lib"
(chmod 777)

Then

su postgres

createdb test_sfcgal -p 5433
createlang plpgsql test_sfcgal -p 5433
psql -d test_sfcgal -p 5433 -f postgis.sql
psql -d test_sfcgal -p 5433 -f spatial_ref_sys.sql
psql -d test_sfcgal -p 5433 -f sfcgal.sql

Thanks again Olivier for help !

Cheers,

Rémi-C

PS : may I suggest to add those lines at the end of the "installation" page
in the github of SFCGAL.
""""""""
*Right now (and until 2.2.0) sfcgal doesn't use EXTENSION*
*so we need to create the spatial database with the old school method:*
*
*
*cd /usr/share/postgresql/9.3/contrib/postgis-2.1*
*psql -d your_database -f postgis.sql
*
*psql your_database -f  spatial_ref_sys.sql*
*psql your_database -f  sfcgal.sql*
""""""""


2013/10/14 Oliver Courtin <olivier.courtin at oslandia.com>

>
> Le 14 oct. 2013 à 15:17, Rémi Cura a écrit :
>
> Rémi,
>
> great news for 2.2, I hope I'll be able to try sfcgal before that :-)
>
>
> :)
>
> the postgis.sql breaks at the 2nd statement with the classical :
>
> ERROR: could not load library "/usr/lib/postgresql/9.3/lib/postgis-2.1.so":
> libSFCGAL.so: cannot open shared object file: No such file or directory
> État SQL :58P01
>
>
> what now?
>
>
>
> Did you done a ldconfig ?
>
> What give a :
> ldconfig -v | grep -i sfcgal
>
>
> What give also a:
> ldd /usr/lib/postgresql/9.3/lib/postgis-2.1.so
>
>
> O.
>
>
>
>
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20131014/17ee657d/attachment.html>