[postgis-users] Ubuntu and Postgresql9.1.3-2

[Sandro Santilli]

On Thu, May 24, 2012 at 07:27:38AM -0700, Brian H Wilson wrote:
> On 05/24/2012 05:13 AM, José María Amuedo wrote:
> >I understand all steps I have to following to get the installation, but:
> >
> >Do we know if someone installed PostGIS 2 with PostgreSQL 9.1.3-2 in
> >Ubuntu 12_04 LTS????
> >
> >Thanks
> 
> It happens my new desktop has a recent Ubuntu 12.04 install (AWESOME
> new computer! :-), and I don't usually run PostGIS on it (I keep it
> on a server in the other room) so I removed the postgres client
> previously installed on the desktop like this
> 
>  sudo apt-get -f remove postgresql-client postgresql-client-common
> 
> Next I tried these instructions on the computer I am sitting at,
> from the first link I sent yesterday
> 
>  sudo apt-get install python-software-properties
>  sudo apt-add-repository ppa:sharpie/for-science
>  sudo apt-get update
>  sudo apt-get install postgresql-9.1-postgis
> 
> Now I have
> 
>  psql --version
>  psql (PostgreSQL) 9.1.3
>  contains support for command-line editing
> 
> I also have two versions of GDAL installed now, for what it's worth,
> 
>  postgres at laysan:~$ /usr/bin/gdalinfo --version
>  GDAL 1.7.3, released 2010/11/10
>  postgres at laysan:~$ /usr/local/bin/gdalinfo --version
>  GDAL 2.0dev, released 2011/12/29
> 
> I have found having different versions of things can be a problem,
> hence I usually just install things from sources to get all the
> features and most up tp date gdal possible. But for now I press
> on...
> 
> In the past I have always used the procedure outlined on my wiki to
> add PostGIS to PostgreSQL. Therefore creating a geodatabase meant
> using a template. Today I try the command you suggested.
> This is where I have a problem -- using EXTENSION
> 
>  postgres at laysan:~$ createdb test
>  postgres at laysan:~$ psql test
>  psql (9.1.3)
>  Type "help" for help.
> 
>  test=# CREATE EXTENSION postgis;
>  ERROR:  function st_asgml(integer, geography, integer, integer,
> text,  text) does not exist
>  test=#
> 
> Seems like I got further than you José but still encountered a problem.

It's a recent bug. Someone packaged a broken revision of PostGIS.
Current trunk is fine, if you mail the package maintainer he'll know
what to do.

--strk; 

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
  `-o------'