<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1479" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm updating postgis to 1.0.0 cvs from 0.9
version.</FONT></DIV>
<DIV><FONT face=Arial size=2>For this purpose I use the postgis_restore.pl
script.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have 2 postgres server:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> the 8.0.0 beta5 with postgis 0.9
(port 5432)</FONT></DIV>
<DIV><FONT face=Arial size=2> and the 8.0.0 RC1 with the
postgis-cvs (1.0.0) port 5433</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>$ pg_dump -Fc mydb >mydb.dump</FONT></DIV>
<DIV><FONT face=Arial size=2>$ postgis_restore.pl lwpostgis.sql myNEWdb
mydb.dump 5433</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Now, when I run the script (I have modified it in
order to create the new database at the port 5433) I notice that It
installs the old 0.9 postgres libraries! but I use the lwpostgis.sql script that
comes with the cvs version!</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>PS. The old database with Postgis0.9 was
created with a postgis.sql script where I replaced the $libdir variable with the
absolute path of the 0.9 libraries. Can be this a problem?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Thanks in advance.</FONT></DIV>
<DIV><FONT face=Arial size=2>RedS</FONT> </DIV></BODY></HTML>