[postgis-users] Setup postgis 1.2 problem on Windows

[Eric FRANCOIS]

Hello,

I have an error on Postgis 1.2 setup on Postgres 8.2 for Windows after dump
all my databases from Postgres 8.15 and restore them on new Postgres.



After removing postgis 1.6 via the uninstaller of Postgres 8.2, I try to
load the postgis 1.2 for Windows.

I have this error


Checking for existing PostGIS installation...
Removing existing template_postgis database...
Output folder: C:\Program Files\PostgreSQL\8.2\bin
Extract: libgeos-2.dll... 100%
Extract: libgeos_c-1.dll... 100%
Extract: libproj.dll... 100%
Extract: pgsql2shp.exe... 100%
Extract: shp2pgsql.exe... 100%
Output folder: C:\Program Files\PostgreSQL\8.2\doc\contrib
Extract: README.pgsql2shp... 100%
Extract: README.postgis... 100%
Extract: README.shp2pgsql... 100%
Output folder: C:\Program Files\PostgreSQL\8.2\doc\contrib\html\postgis
Extract: postgis.html... 100%
Extract: style.css... 100%
Output folder: C:\Program Files\PostgreSQL\8.2\jdbc
Extract: postgis_1.2.0.jar... 100%
Output folder: C:\Program Files\PostgreSQL\8.2\lib
Extract: liblwgeom.dll... 100%
Output folder: C:\Program Files\PostgreSQL\8.2\share\contrib
Extract: lwpostgis.sql... 100%
Extract: spatial_ref_sys.sql... 100%
Output folder: C:\Program Files\PostgreSQL\8.2\share\contrib\postgis
Extract: lwpostgis_upgrade.sql... 100%
Output folder: C:\Program
Files\PostgreSQL\8.2\share\contrib\postgis\topology
Extract: README... 100%
Extract: topology.sql... 100%
Output folder: C:\Program Files\PostgreSQL\8.2\share\contrib\postgis\utils
Extract: create_undef.pl... 100%
Extract: postgis_proc_upgrade.pl... 100%
Extract: postgis_restore.pl... 100%
Creating template database...
Loading PLPGSQL language...
Database installation of PLPGSQL failed.
Database installation of PLPGSQL failed.


The log:
2006-12-13 18:58:32 LOG:  statement: CREATE DATABASE template_postgis
ENCODING 'UNICODE';

2006-12-13 18:58:51 LOG:  duration: 19187.999 ms
2006-12-13 18:58:51 LOG:  statement: SELECT oid FROM pg_catalog.pg_language
WHERE lanname = 'plpgsql';
2006-12-13 18:58:51 LOG:  duration: 0.000 ms
2006-12-13 18:58:51 LOG:  statement: UPDATE pg_database SET
datistemplate='t' WHERE datname='template_postgis'
2006-12-13 18:58:51 LOG:  duration: 109.000 ms





Thanks for help

ERIC