<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-2" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16535"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=931153119-23042010><FONT color=#0000ff
size=2 face=Arial>Marko,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=931153119-23042010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=931153119-23042010><FONT color=#0000ff
size=2 face=Arial>Not sure off hand what could be wrong here. Did you
verify the table you can't visualize has data?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=931153119-23042010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=931153119-23042010><FONT color=#0000ff
size=2 face=Arial>Its possible the data didn't load or didn't get backed up
because it had a very invalid geometry in it like a polygon with two few
points. This issue was fixed in PostGIS 1.4.2 and PostGIS 1.5.1.
Before it was possible that you could create a record in PostGIS that was
clearly invalid and you would no longer be able to export it out or reimport
it. We are guessing that might be the issue here.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=931153119-23042010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=931153119-23042010><FONT color=#0000ff
size=2 face=Arial>Leo and Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=931153119-23042010><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=931153119-23042010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Marko
Cubranic<BR><B>Sent:</B> Friday, April 23, 2010 3:27 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] restore
database<BR></FONT><BR></DIV>
<DIV></DIV>Dear,<BR><BR>i have made backup of spatial database and after i v
restored it i couldn't visualize <BR>one geometry table in Qgis,
uDIG,FME-viewer.Before i did backup of database i could visualize all data.<BR>I
did backup and restore on same computer with PostgreSQL 8.3
installed.<BR>Database consists of 7 geometry tables, which 2 of geometry tables
are loaded from shapefile, and one of those two<BR>cannot be visualized after
backup and restore. <BR><BR>So if anyone can help, thank you.<BR><BR><BR
clear=all><BR>-- <BR>Marko Èubraniæ<BR></BODY></HTML>