oog + postgis   45

Digital Geography
Seems at first blush to work with postgresql-9.3 and postgis-2.1, but conflicts with apt-get upgrade trying to install postgresql-9.1.

Had to install libgdal1 for the postgresql-9.3 installation to work. there was a time when psql-9.3.x was running postgresql-9.1. maybe libgdal1-dev would have been a better choice. This may have been messed up by previous installation attempts, however.
postgis  postgresql  installation  succ  libgdal1  library  gis 
august 2014 by oog
UsersWikiPostGIS21UbuntuPGSQL93Apt – PostGIS
bkm@asusquad ~ $ shp2pgsql-gui
The program 'shp2pgsql-gui' is currently not installed. You can install it by typing:
sudo apt-get install postgis

The following describes how to install Postgresql 9.3, PostGIS 2.1, PGAdmin 1.18.1 and shp2pgsql-gui on Ubuntu versions 12.04 through 13.10. (NOTE: These instructions do not work with Ubuntu 14.04) <- damn!
postgresql  unsucc  postgis  psql2shp  shp2pgsql  installation  howto  geodatabase 
august 2014 by oog
postgis - How to view error feedback in qgis when testing connection to postgres database? - GIS
ou can also set your IPv4 connection to use trust which should allow you to connect locally.
posgres  postgis  qgis  error_message 
january 2013 by oog
PostGIS Quickstart — OSGeo-Live 6.0 Documentation
demo=# SELECT AddGeometryColumn ( 'cities', 'the_geom', 4326, 'POINT', 2); <- this fails with a postgis2 installation
postgis  gis  geodatabase  geospatial  cli  command_line 
january 2013 by oog
Chapter 3. PostGIS Frequently Asked Questions
The legacy.sql file is located in the same folder as postgis.sql. You can install this file after you have installed postgis.sql and spatial_ref_sys.sql to get back all the 200 some-odd old functions we removed.
postgis  postgis2  legacy  functions 
january 2013 by oog
Chapter 2. Installation
After compiling you should find several postgis_upgrade*.sql files.
postgresql  postgis  upgrade  hard_upgrade  soft_upgrade 
january 2013 by oog
#1529808: Support PostGIS 2.x - Update usage of non-prefixed functions | drupal.org
A temporarily solution for those using PostGIS 2.x is to run the bundled legacy.sql script on your database which will add support for non-prefixed function calls. This can easily be uninstalled with the matching uninstall_legacy.sql script.

Substituting "GeomFromText" with "ST_GeomFromText" on lines 544 and 588 in file sync_postgis.module solves this bug. :)
postgis  postgresql  geodatabase  geospatial  bug 
january 2013 by oog
delicious robots blog
Password for user someuser: psql: FATAL:  Peer authentication failed for user "someuser" Oops. Your password didn't work, asshole. Instead, you need to open up this file /etc/postgresql/9.1/main/pg_hba.conf in a text editor (with root privileges, of course) and change this line: local   all             all                                     peer
postgis  peer  local  md5  database  error_message  ubuntu  postgresql  authentication  admin  permissions 
january 2013 by oog
c roadmaps gisadmin;
FATAL: Peer authentication failed for user "gisadmin"

ERROR: function geomfromtext(unknown, integer) does not exist
LINE 2: VALUES (1, GeomFromText('LINESTRING(0 10,0 0)', -1),

(see the peer pinboard.in/u:oog tag)
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

[the answer seems to be to specify: ST_GeomFromText()]
postgis  sql  geodatabase  geospatial  clickety_clickety  peer 
january 2013 by oog
UsersWikiPostGIS20Ubuntu1204 – PostGIS
The compile option works. But apt-cacher-ng must be removed....

At first blush mostly works for postgresql 9.3 and postgis 2.1.
postgresql  succ  postgis  tutorial  installation  compile  ubuntu  linux  unix 
january 2013 by oog
Version 4.0 screenshots are up
archeos  linux  distro  debian  unix  gis  geodatabase  postgis 
april 2010 by oog

Copy this bookmark: