<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-GB link=blue vlink=purple>
<BR>
<BR>
<div class=WordSection1>
<p class=MsoNormal>Hi<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I am in the process of upgrading PostgreSQL 8.2 to 9.0 and
Postgis 1.2.1 to 1.5.2-3. The installations went well once I had logged
onto the server as a local administrator, however this where I hit a problem.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I am transferring the data by running pg_dump on the 8.2
server and using pg_restore on the 9.0 server. Most of the data is
restored, however there are instances in the new tables where the geometry
columns are blank where they were once populated. This is causing an
issue when I try and load the data layer in to my GIS application.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Does anyone have any thoughts/solution to this?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Cheers<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Graeme<o:p></o:p></p>
</div>
<BR>
<BR>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";
color:gray'>---------------------------------------------------------------------------------------------------------------------<br>
This email and any files transmitted with it are confidential and intended
solely for the use <br>
of the individual or entity to whom they are addressed. If you have
received this email in <br>
error please let us know by email reply and delete it from your system. <br>
<br>
Please note that any views or opinions presented in this email are solely
those of the <br>
author and do not necessarily represent those of Grand Union Housing Group.
<br>
<br>
Finally, the recipient should check this email and any attachments for the
presence of viruses. <br>
Grand Union Housing Group accepts no liability for any damage caused by any
virus <br>
transmitted by this email. <br>
<br>
<strong><u><span style='font-family:"Verdana","sans-serif"'>Grand Union
Housing Group</span></u></strong><br>
Registered Office: <br>
Katherines House<br>
Dunstable Street<br>
Ampthill<br>
Bedfordshire<br>
MK45 2JP <br>
Registered under the Industrial and Provident Societies Act 1965 Registered
No. 30388R <br>
Housing Corporation Registered No. L4518 <br>
<br>
<a href="http://www.grandunionhousing.co.uk/">http://www.grandunionhousing.co.uk</a><br>
--------------------------------------------------------------------------------------------------------------------</span><o:p></o:p></p>
</td>
<td style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> </span><o:p></o:p></p>
</td></body>
</html>