[postgis-users] Setup postgis 1.2 problem on Windows

[Mark Cave-Ayland]

On Wed, 2006-12-13 at 20:51 +0100, Eric FRANCOIS wrote:
> 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


Hi Eric,

What's happening is that because I couldn't find a way to detect a
successful execution of createlang, it assumes that any output from the
createlang executable is an error. It appears as if your logging level
in postgresql.conf is set to a very high level (outputting a line for
every SQL statement) and this is enough to make the installer think that
something has gone wrong and cause it to stop.

You should be able to complete the installation by temporarily
decreasing the log level of your PostgreSQL 8.2 server, re-running the
PostGIS installer, and then turning the log level back up again.


Kind regards,

Mark.