<!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.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=629510915-20012006><FONT face=Arial size=2>>>The
postgis_restore.pl could create the dump list and also the dump ascii but then
gives an error because it does not allow me to write down the password at the
next >>step. </FONT></SPAN></DIV>
<DIV><SPAN class=629510915-20012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=629510915-20012006><FONT face=Arial size=2>I was having a
simmilar problem. Each time I'd run postgis_restore.pl It would promt for
my password 3 time before bailing, indicating that the password was incorrect.
It was pointed out to me that this can be avoided by setting the following
environment variables, PGUSER and PGPASSWORD. I also found it useful to specify
PGHOST, PGPORT, and PGDATA as well. You can set the env variable at the cmmd
prompt like this:</FONT></SPAN></DIV>
<DIV><SPAN class=629510915-20012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=629510915-20012006><FONT face=Arial size=2>>set
PGUSER=username</FONT></SPAN></DIV>
<DIV><SPAN class=629510915-20012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=629510915-20012006><FONT face=Arial size=2>or you can set the
in controlpanel-->system-->advanced--></FONT></SPAN></DIV>
<DIV><SPAN class=629510915-20012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=629510915-20012006><FONT face=Arial size=2>hope that
helps</FONT></SPAN></DIV>
<DIV><SPAN class=629510915-20012006><FONT face=Arial
size=2>Jeremy</FONT></SPAN></DIV>
<DIV><SPAN class=629510915-20012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=629510915-20012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net]<B>On Behalf Of
</B>Mario Servin<BR><B>Sent:</B> January 20, 2006 10:06 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users]
Upgrading from PostgreSQL 8.0 with PostGIS 0.9 to PostgreSQL 8.1 with PostGIS
1.0<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Hi everybody,</FONT></DIV>
<DIV><FONT face=Arial size=2>I failed completely to restore my data from a
PostgreSQL 8.0 with PostGIS 0.9 to PostgreSQL 8.1 with PostGIS 1.0. I have
both versions of PosgreSQL running in Windows. I follow instructions in
PostGIS docs from the PostgreSQL installation for upgrading. The
postgis_restore.pl could create the dump list and also the dump ascii but then
gives an error because it does not allow me to write down the password at the
next step. As I know something about Perl I tried to modify the
script without success. </FONT></DIV>
<DIV><FONT face=Arial size=2>Additionally, I still have the results from
the old shp2pgsql and so I tried to insert the data form psql using \i
mysqlinsertionscript.sql. Tables are created ok, but geom columns results in
meaningless characters where it is supossed to be something like "POINT (-
66.046532 -21.951437)" for example.</FONT></DIV>
<DIV><FONT face=Arial size=2>Can anybody help me?.</FONT></DIV>
<DIV><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV><FONT face=Arial size=2>
Mario Servin</FONT></DIV></BLOCKQUOTE></BODY></HTML>