[postgis-users] Installing on Ubuntu via Postgresql APT repository
All, Just for kicks yesterday I tried installing Postgresql 9.3 on Ubuntu from their APT repository. I also added a postgis flag in there and it seems to have all come in very nicely! Here's what I did based on instructions here: http://wiki.postgresql.org/wiki/Apt * *run:* /sudo gedit /etc/apt/sources.list/ *add to bottom:* #postgresql9.3 deb http://apt.postgresql.org/pub/repos/apt//precise/-pgdg main * run:* wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add - sudo apt-get update /sudo apt-get install postgresql-9.3-postgis pgadmin3/ *Create new PGSQL user:* sudo su - postgres createuser -d -E -i -l -P -r -s matthew_baker ** Once logged in, all the extensions are available, including postgis, postgis_topology, and postgis_tiger_geocoder... Also, shp2pgsql-gui runs from terminal...(great!) And when connected through QGIS 2.0, it works! A version check yields: POSTGIS=2.1.0 r11822 GEOS=3.3.3-CAPI-1.7.4 PROJ=Rel. 4.7.1, 23 September 2009 GDAL=GDAL 1.9.0, released 2011/12/29 LIBXML=2.7.8 LIBJSON=UNKNOWN RASTER PostgreSQL 9.3.0 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit So it seems I'm missing LIBJSON...? Any thoughts appreciated! Hoping this fills a hole in the Ubuntu installation... -m ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] Installing on Ubuntu via Postgresql APT repository
Just to clarify, I was wondering if this was indeed a valid installation of PostGIS 2.1 and Postgresql 9.3 I had only seen a reference to the Postgresql APT repository as The PostgreSQL build team is working on an APT repository https://wiki.postgresql.org/wiki/Apt for PostgreSQL builds. They may include PostGIS builds in the future. from http://postgis.net/install Thanks, -m On 10/01/2013 10:06 AM, Matthew Baker wrote: All, Just for kicks yesterday I tried installing Postgresql 9.3 on Ubuntu from their APT repository. I also added a postgis flag in there and it seems to have all come in very nicely! Here's what I did based on instructions here: http://wiki.postgresql.org/wiki/Apt * *run:* /sudo gedit /etc/apt/sources.list/ *add to bottom:* #postgresql9.3 debhttp://apt.postgresql.org/pub/repos/apt/ /precise/-pgdg main * run:* wget --quiet -O -http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add - sudo apt-get update /sudo apt-get install postgresql-9.3-postgis pgadmin3/ *Create new PGSQL user:* sudo su - postgres createuser -d -E -i -l -P -r -s matthew_baker ** Once logged in, all the extensions are available, including postgis, postgis_topology, and postgis_tiger_geocoder... Also, shp2pgsql-gui runs from terminal...(great!) And when connected through QGIS 2.0, it works! A version check yields: POSTGIS=2.1.0 r11822 GEOS=3.3.3-CAPI-1.7.4 PROJ=Rel. 4.7.1, 23 September 2009 GDAL=GDAL 1.9.0, released 2011/12/29 LIBXML=2.7.8 LIBJSON=UNKNOWN RASTER PostgreSQL 9.3.0 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit So it seems I'm missing LIBJSON...? Any thoughts appreciated! Hoping this fills a hole in the Ubuntu installation... -m ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[postgis-users] PostGIS 2.1.0 Bundle and PostGIS 2.0.4 on stackbuilder
We have PostGIS 2.1.0 Bundle for 9.3 and 9.2 available on Stackbuilder. PostGIS 2.0.4 is also available on Stackbuilder as well for 9.2 (32-bit and 64-bit). We are still working on getting out the 9.0 and 9.1 PostGIS 2.0.4 builds on stackbuilder. As stated before, we aren't going to be providing stackbuilder builds for 2.1.0 for lower than 9.2, but binaries for 9.1 and 9.0 64-bit are available On winnie PostGIS bot http://postgis.net/windows_downloads for those running lower PostgreSQL (9.0-9.1 64-bit) versions that want to upgrade to 2.1.0. Please test and repot back with any issues. Thanks for your cooperation, Regina and Leo http://www.postgis.us http://postgis.net ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] dump/restore permission
Which version of PostGIS and PostgreSQL are you running? I think if you install with CREATE EXTENSION the permissions may not come back, but those should be public anyway. I believe in PostGIS 2.0.4 (or was it 2.0.3), can't remember, we changed to explicitly set these to public read since they are views and will only list tables user has access to. Thanks, Regina http://www.postgis.us -Original Message- From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Mario Jurcevic Sent: Monday, September 30, 2013 9:32 AM To: postgis-us...@postgis.refractions.net Subject: [postgis-users] dump/restore permission Hi, after pg_dump/restore each time the permission on geometry_columns and geography_columns are lost. Why of that? Thanks. -- Mario ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[postgis-users] ST_GeomFromText vs ST_MakeEnvelope
Hello All, I'm trying to understand why I get different results in PostGIS 2.1/Postgresql 9.2. using the following queries: select name, ST_AsText(a.geom) as geom from cities a where a.geom ST_MakeEnvelope(-107,39, -102, 42, 4326); select name, ST_AsText(a.geom) as geom from cities a where a.geom ST_GeomFromText('POLYGON((-107 39, -102 39, -102 42, -17 42, -107 39))', 4326); Can someone please explain? Thanks! --john ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users