[postgis-users] restore database

[Marko Čubranić]

Leo and Regina,

I have verified my table , and table contanis one object geometry (about 40
000 points).
Maybe the problem is in too large object.

Marko

2010/4/23 Paragon Corporation <lr at pcorp.us>

>  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ć
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>


-- 
Marko Čubranić
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100426/4b9a23c1/attachment.html>