<!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><FONT face=Arial color=#0000ff size=2><SPAN class=829170119-20012006>Hi
All,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=829170119-20012006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=829170119-20012006>Perhaps someone with more experience than I could offer
a quick explanation to the following ...</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=829170119-20012006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=829170119-20012006>I have
two *identical* installations of postgresql8.1 with PostGIS on win32 lets say
installation A and B. The only obvious difference between the two is that
installation A has its data dir as c:\program files\postgres\8.1\data and
installation B has its data dir as I:\anotherdir\data (postgresql's system files
and what not are in the default c:\program files\postgres\8.1\bin for both
installations).</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=829170119-20012006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=829170119-20012006>I have
a dump file to be restored into both databases. The dump is in custom format
created with the pg_dump -Fc option.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=829170119-20012006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=829170119-20012006>When I
restore the data to installation A, all seems to go well.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=829170119-20012006>When I
restore the data to installation B, I get the following error msg as the last
msg in my terminal screen:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=829170119-20012006></SPAN></FONT> </DIV><FONT face=Arial
color=#0000ff size=2><SPAN class=829170119-20012006>
<P class=MsoBodyText style="MARGIN: 0pt; TEXT-ALIGN: left" align=left><SPAN
lang=EN-US style="FONT-FAMILY: 'Courier New'"><FONT size=3><FONT
color=#000000>ERROR:<SPAN style="mso-spacerun: yes"> </SPAN>syntax error
at or near "16" at character 1<?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" /><o:p></o:p></FONT></FONT></SPAN></P>
<DIV><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Courier New'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-CA; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><FONT
color=#000000>LINE 1: 16 BU_WHDATABASE Backup Warehouse
Database</FONT></SPAN></DIV>
<DIV><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Courier New'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-CA; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><SPAN
class=829170119-20012006><FONT color=#000000></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Courier New'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-CA; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><FONT
face=Arial size=2><SPAN class=829170119-20012006>also I notice that in my public
schema, on the geometry_column table there are no
records.</SPAN></FONT></SPAN></DIV>
<DIV><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Courier New'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-CA; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><FONT
face=Arial size=2><SPAN class=829170119-20012006>Why is this the case? Does
having my data dir on another drive have anything to do with it?
</SPAN></FONT></SPAN></DIV>
<DIV><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Courier New'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-CA; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><FONT
face=Arial size=2><SPAN
class=829170119-20012006></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Courier New'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-CA; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><FONT
face=Arial size=2><SPAN class=829170119-20012006>Finally and perhaps most
relevant to determing what's up: Is there a function I can execute that
will spit out a complete list of all of the functions, versions, upgrades
etc that are make up a database? Ideally what Id like to do is obtain such a
report from both installations, then compare the two.</SPAN></FONT></SPAN></DIV>
<DIV><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Courier New'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-CA; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><FONT
face=Arial size=2><SPAN
class=829170119-20012006></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Courier New'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-CA; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><FONT
face=Arial size=2><SPAN class=829170119-20012006>Best
Regards</SPAN></FONT></SPAN></DIV>
<DIV><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Courier New'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-CA; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><FONT
face=Arial size=2><SPAN
class=829170119-20012006>Jeremy</SPAN></FONT></SPAN></DIV>
<DIV><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Courier New'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-CA; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><FONT
face=Arial size=2><SPAN
class=829170119-20012006></SPAN></FONT></SPAN></SPAN></FONT> </DIV>
<BLOCKQUOTE><FONT face=Arial color=#0000ff
size=2></FONT> </BLOCKQUOTE></BODY></HTML>