<!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=621353816-20012006><FONT face=Arial color=#0000ff size=2>Hi
All,</FONT></SPAN></DIV>
<DIV><SPAN class=621353816-20012006><FONT face=Arial color=#0000ff size=2>Im
seeking advice on the following,</FONT></SPAN></DIV>
<DIV><SPAN class=621353816-20012006><FONT face=Arial color=#0000ff size=2>I have
recently preformed a restore on a post enabled database. Everything looks fine
except for the 'geometry_columns' table in the 'public' schema. In my original
database this table seems to hold records of all of the geomerty columns from
other tables, however in the new database this table has no records. Have I
missed somthing in the process or restoring the database? What do I need to do
to populate (fix) my 'geometry_columns' table??</FONT></SPAN></DIV>
<DIV><SPAN class=621353816-20012006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=621353816-20012006><FONT face=Arial color=#0000ff size=2>Best
Regards</FONT></SPAN></DIV>
<DIV><SPAN class=621353816-20012006><FONT face=Arial color=#0000ff
size=2>Jeremy</FONT></SPAN></DIV>
<BLOCKQUOTE>
<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 11:01 AM<BR><B>To:</B>
PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users] Upgrading from
PostgreSQL 8.0 with PostGIS 0. 9 to PostgreSQL 8.1 with PostGIS
1.0<BR><BR></FONT></DIV>
<DIV>Thanks Jeremy. I used that and now postgis_restore works to the end.
Unfortunately the geom column of my data again appear as a strange string of
characters where I expected to see something as POINT, LINE etc. I do not know
what else can I do ..... <BR><BR> </DIV>
<DIV><SPAN class=gmail_quote>On 1/20/06, <B class=gmail_sendername>Sears,
Jeremy</B> <<A
href="mailto:Jeremy.Sears@ccrs.nrcan.gc.ca">Jeremy.Sears@ccrs.nrcan.gc.ca</A>>
wrote:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><SPAN
class=q>
<DIV><SPAN><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><FONT face=Arial size=2></FONT></SPAN> </DIV></SPAN>
<DIV><SPAN><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><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN><FONT face=Arial size=2>>set
PGUSER=username</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN><FONT face=Arial size=2>or you can set the in
controlpanel-->system-->advanced--></FONT></SPAN></DIV>
<DIV><SPAN><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN><FONT face=Arial size=2>hope that helps</FONT></SPAN></DIV><SPAN
class=sg>
<DIV><SPAN><FONT face=Arial size=2>Jeremy</FONT></SPAN></DIV></SPAN>
<DIV><SPAN class=e id=q_108e862b8dd0827a_3>
<DIV><SPAN><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN><FONT face=Arial size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV dir=ltr align=left><FONT face=Tahoma size=2>-----Original
Message-----<BR><B>From:</B> <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:postgis-users-bounces@postgis.refractions.net"
target=_blank>postgis-users-bounces@postgis.refractions.net</A> [mailto:<A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:postgis-users-bounces@postgis.refractions.net"
target=_blank>postgis-users-bounces@postgis.refractions.net </A>]<B>On
Behalf Of </B>Mario Servin<BR><B>Sent:</B> January 20, 2006 10:06
AM<BR><B>To:</B> <A onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.refractions.net
</A><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></SPAN></DIV><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
onclick="return top.js.OpenExtLink(window,event,this)"
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users
</A><BR><BR><BR></BLOCKQUOTE></DIV><BR></BLOCKQUOTE></BODY></HTML>