id,summary,reporter,owner,description,type,status,component,version,severity,resolution,keywords,cc,stage,has_patch,needs_docs,needs_tests,needs_better_patch,easy,ui_ux 17894,create_template_postgis-debian.sh fails on Ubuntu 11.10,John Paulett,nobody,"Ubuntu 11.10 upgraded to PostgreSQL 9.1, thus the path to the PostGIS files have changed again (to /usr/share/postgresql/9.1/contrib/postgis-1.5) Additionally it appears that plpsql is now installed in the template database by default, resulting the failure of the createlang command, which causes following commands to not be executed: {{{ createlang: language ""plpgsql"" is already installed in database ""template_postgis"" }}} On a fresh Ubuntu 11.10 install: {{{ $ sudo -u postgres psql psql (9.1.3) Type ""help"" for help. postgres=# \dL List of languages Name | Owner | Trusted ---------+----------+--------- plpgsql | postgres | t (1 row) }}} The attached patch adds the path to PostgreSQL 9.1 and only runs createlang for older version.",Bug,closed,GIS,dev,Normal,duplicate,,john@…,Unreviewed,1,0,0,0,0,0