[postgis-users] restore database

[Paragon Corporation]

Marko,
 
Not sure off hand what could be wrong here.  Did you verify the table you
can't visualize has data?
 
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.
 
Leo and Regina
http://www.postgis.us
 

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Marko
Cubranic
Sent: Friday, April 23, 2010 3:27 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] restore database


Dear,

i have made backup of spatial database and after i v restored it i couldn't
visualize 
one geometry table in Qgis, uDIG,FME-viewer.Before i did backup of database
i could visualize all data.
I did backup and restore on same computer with PostgreSQL 8.3 installed.
Database consists of 7 geometry tables, which 2 of geometry tables are
loaded from shapefile, and one of those two
cannot be visualized after backup and restore. 

So if anyone can help, thank you.



-- 
Marko Čubranić

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100423/436e85e0/attachment.html>