[postgis-users] PostGIS 2.2 Debian package based on Postgresql 9.5 for trusty ( ubuntu 14.04)

[Pallavi Sontakke]

Hi All,

I was looking to install PostGIS 2.2  to work with Postgresql 9.5 on my trusty system. As I did not find any available debian packages for trusty, I was trying to build from PostGIS source. However, even after getting many other binaries, could not get all modules of PostGIS working (especially postgis_sfcgal and address_standardizer).

Could you please point me to trusty packages if available? Also, if not, could you please let me know when would they be available?

Thanks,

Pallavi

[Jorge Gustavo Rocha]

Hi Pallavi,

Follow http://www.postgresql.org/download/linux/ubuntu/

Summary:

echo "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main" |
sudo tee /etc/apt/sources.list.d/pgdg.list

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc |
sudo apt-key add -

sudo apt-get update

sudo apt-get install postgresql-9.5 postgresql-9.5-postgis-2.2
postgresql-contrib postgresql-client-9.5

Regards,

> _______________________________________________
> postgis-users mailing list
> postgi...@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
>

J. Gustavo
--
Jorge Gustavo Rocha
Departamento de Informática
Universidade do Minho
4710-057 Braga
Tel: +351 253604480
Fax: +351 253604471
Móvel: +351 910333888
skype: nabocudnosor
_______________________________________________
postgis-users mailing list
postgi...@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

[Regina Obe]

I created this updated page for PostGIS 2.2 / PostgreSQL 9.5 / pgRouting 2.1 based on my experience installing on an Ubuntu Trusty server. Feel free to update it

https://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS22UbuntuPGSQL95Apt

Also updated link on this page http://postgis.net/install/ to point to newer instructions

Still got to update the CentOS/ RedHat instructions for 2.2

Thanks,
Regina

-----Original Message-----
From: postgis-users [mailto:postgis-us...@lists.osgeo.org] On Behalf Of Jorge Gustavo Rocha
Sent: Thursday, February 11, 2016 6:10 AM
To: postgi...@lists.osgeo.org
Subject: Re: [postgis-users] PostGIS 2.2 Debian package based on Postgresql 9.5 for trusty ( ubuntu 14.04)

Hi Pallavi,

Follow http://www.postgresql.org/download/linux/ubuntu/

Summary:

echo "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main" | sudo tee /etc/apt/sources.list.d/pgdg.list

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

sudo apt-get update

sudo apt-get install postgresql-9.5 postgresql-9.5-postgis-2.2 postgresql-contrib postgresql-client-9.5

Regards,

s 10:37 de 11-02-2016, Pallavi Sontakke escreveu:

> Hi All,
>
> I was looking to install PostGIS 2.2 to work with Postgresql 9.5 on
> my trusty system. As I did not find any available debian packages for
> trusty, I was trying to build from PostGIS source. However, even after
> getting many other binaries, could not get all modules of PostGIS
> working (especially postgis_sfcgal and address_standardizer).
>
> Could you please point me to trusty packages if available? Also, if
> not, could you please let me know when would they be available?
>
> Thanks,
> Pallavi
>
>
> _______________________________________________
> postgis-users mailing list
> postgi...@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
>

J. Gustavo
--
Jorge Gustavo Rocha

Departamento de Inform tica

Universidade do Minho
4710-057 Braga
Tel: +351 253604480
Fax: +351 253604471

M vel: +351 910333888

skype: nabocudnosor
_______________________________________________
postgis-users mailing list
postgi...@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

[Pallavi Sontakke]

Hi All,

Thanks for the debian packages for trusty for PostGIS.

As in my current work I am looking to use PostGIS with a custom-built Postgresql (with some changes on top of Postgresql 9.5.0), I am required to build PostGIS 2.2.1 from source.

As a first step, am trying to build PostGIS from source for Postgresql 9.5.0

In line, I downloaded postgis-2.2.1.tar.gz from http://postgis.net/source/

However, during './configure' am getting this error:

checking for geos_c.h... yes
checking for initGEOS in -lgeos_c... yes
checking for sfcgal-config... /usr/local/bin/sfcgal-config
configure: error: PostGIS requires SFCGAL >= 1.1.0 (found 1.0.0)

On trusty by default version 1.0.0 of SFCGAL is available. Also in my previous PostGIS source-build attempt, build of SFCGAL 1.2.1 required CGAL 4.7 and still SFCGAL did not get installed properly. Also I noticed that in Debian trusty PostGIS packages you uploaded, postgis_sfcgal was missing.

I don't need postgis_sfcgal specifically as such, so ran configure with option --without-sfcgal.

However, due to it, address_standardizer has also got disabled (It was available in trusty package you had created). Could you please show me a way, that address_standardizer can be enabled, even if postgis_sfcgal is not there?

Thanks,
 Pallavi

[Pieter du Plooy]

Hi Pallavi

I used a Postgres 9.5 from the postgres pgdg repository, and compiled everything else from scratch (Trusty).

I used Vincent Picavet's pggis dockerfile as a guide:

https://raw.githubusercontent.com/vpicavet/docker-pggis/master/Dockerfile

He used cgal 4.3 and sfcgal from git

It worked a charm for me.

Pieter

On Thu, Feb 18, 2016 at 8:05 AM, Pallavi Sontakke <pallavi....@2ndquadrant.com> wrote:

Hi All,

Thanks for the debian packages for trusty for PostGIS.

As in my current work I am looking to use PostGIS with a custom-built Postgresql (with some changes on top of Postgresql 9.5.0), I am required to build PostGIS 2.2.1 from source.

As a first step, am trying to build PostGIS from source for Postgresql 9.5.0

In line, I downloaded postgis-2.2.1.tar.gz from http://postgis.net/source/

However, during './configure' am getting this error:

checking for geos_c.h... yes
checking for initGEOS in -lgeos_c... yes
checking for sfcgal-config... /usr/local/bin/sfcgal-config
configure: error: PostGIS requires SFCGAL >= 1.1.0 (found 1.0.0)

On trusty by default version 1.0.0 of SFCGAL is available. Also in my previous PostGIS source-build attempt, build of SFCGAL 1.2.1 required CGAL 4.7 and still SFCGAL did not get installed properly. Also I noticed that in Debian trusty PostGIS packages you uploaded, postgis_sfcgal was missing.

I don't need postgis_sfcgal specifically as such, so ran configure with option --without-sfcgal.

However, due to it, address_standardizer has also got disabled (It was available in trusty package you had created). Could you please show me a way, that address_standardizer can be enabled, even if postgis_sfcgal is not there?

Thanks,
 Pallavi

On 11 February 2016 at 16:07, Pallavi Sontakke <pallavi....@2ndquadrant.com> wrote:

Hi All,

I was looking to install PostGIS 2.2  to work with Postgresql 9.5 on my trusty system. As I did not find any available debian packages for trusty, I was trying to build from PostGIS source. However, even after getting many other binaries, could not get all modules of PostGIS working (especially postgis_sfcgal and address_standardizer).

Could you please point me to trusty packages if available? Also, if not, could you please let me know when would they be available?

Thanks,

Pallavi