[postgis-users] restore database

[Paragon Corporation]

Marko,
 
Can't think of why number of points would make a difference if it showed up
before.  That could mean a bug of some sort in newer PostGIS in which case,
it would be great to get a bug report with an attachment of the offending
table.  
 
Before that though - lets rule out some non-bug possibilities.
 
When you restored -- did you restore to a new version of PostGIS or same
version and which version of PostGIS are you running now and before?
 
One common possibility is that the spatial_ref_sys record is not registered
for the srid of this table.  Since QGIS/FME are srid aware, they might not
be showing it because its off in la la land to them.  
 
What often causes this behavior is if you restored on top of a new PostGIS
template database any custom records that were added/modified to
spatial_ref_sys may be lost.  To rule this out
 
1) What is the srid of this table and verify it exists in spatial_ref_sys
2) If it does exist, do a SELECT proj4text from spatial_ref_sys where srid =
srid_here  on both the old working database and the new database and verify
they return the same answer.
 
If that isn't the issue
 
To rule point out, you can dump the data into a new table and simplify it to
reduce number of points
http://www.postgis.org/documentation/manual-svn/ST_SimplifyPreserveTopology.
html
 
SELECT gid, ST_SimplifyPreserveTopology(the_geom, 1000) As the_geom
INTO newtable
FROM badtable
 
The 1000 is in units of spatial coordinate  (so if your data is in long lat
use something like 0.01 or something instead)
 
The count of your points in your new table should then be much lower. If
that still doesn't display then not a number of points issue.  Either way if
its a number of points or some other issue, would be nice to get a bug
report.
 
http://trac.osgeo.org/postgis/newticket
 
which you will need an osgeo account -- http://www.osgeo.org/osgeo_userid
if you don't have one already.
 
Thanks,
Regina and Leo
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: Monday, April 26, 2010 3:16 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] restore database


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/ec925f22/attachment.html>