[postgis-users] Postgis + native Windows PostgreSQL

[TECHER Jean David]

> Is there any other solution than replacing the variable $libdir to the
> full path to postgis.dll?

you can use postgis.sql without chaging $libdir

example if after installation postgis is at c:\pgsql\share\posygis.sql do

psql -d your_database -c "\i c:/psql/lib/share/postgis.sql"
----------------------------------------------------------------
TECHER Jean David
Responsable Informatique 01MAP
e-mail: davidtecher at yahoo.fr
site: http://techer.pascal.free.fr/postgis/
------------------------------------------------------------
----- Original Message -----
From: "Vojtech Honzik" <V.Honzik at sh.cvut.cz>
To: <postgis-users at postgis.refractions.net>
Sent: Thursday, September 30, 2004 2:23 PM
Subject: [postgis-users] Postgis + native Windows PostgreSQL


> Hallo.
> I am trying to move data from the older version of PostgreSQL database.
> After installing Postgresql 8.0-beta2-dev3 and PostGIS 0.9.0 (and
> stopping the database run under Cygwin), there are still errors in the
> error log. I am using psql prior to newer version.
>
> psql -e template1 < db.dump 2> error.txt
>
> error.txt
> -------------
> ...
> NOTICE:  type "histogram2d" is not yet defined
> DETAIL:  Creating a shell type definition.
> ERROR:  could not access file "$libdir/postgis.dll": No such file or
> directory
> ERROR:  type histogram2d does not exist
> ERROR:  function histogram2d_in(cstring) does not exist
> NOTICE:  type "box3d" is not yet defined
> DETAIL:  Creating a shell type definition.
> ERROR:  could not access file "$libdir/postgis.dll": No such file or
> directory
> ERROR:  type box3d does not exist
> ERROR:  function box3d_in(cstring) does not exist
> ...
> ------------
>
> I thought that the problem with the different environment would be solved.
> Is there any other solution than replacing the variable $libdir to the
> full path to postgis.dll? In my opinion the standard dump created by
> previous version of PostgreSQL should be usable without editing for
> loading to new native version of database.
>
> Anyway thanks very much to both groups of developers for the release of
> the native Windows version. The performance improvement and locales
> support is perfect.
>
> Best regards,
> Vojtech Honzik
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users