create_template_postgis-debian.sh fails on Ubuntu 11.10
|Reported by:||John Paulett||Owned by:||nobody|
|Has patch:||yes||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
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.