[postgis-users] No Space left on device.

[Richard Heimann [C]]

This question is more to do with PostgreSQL then PostGIS but I've always
gotten good response on this forum and so I'm going back to the well. 

 

After a recent load, I received the following error, ".No space left on
device SQL State 53100 Hint: Check free Disk Space." This error is fairly
self-explanatory but I don't know how to approach the problem. In SQL server
I would simple stop autogrowth on a file group, create a new file group on a
larger partition and be done or alternately attached/detach the database
onto new partition and begin work again. My point is there are several ways
but Im new to PostrgeSQL and Im curious - what's the best practice. I
believe all the data is in the installation directory <data> folder. Can I
simply move this folder and somehow reattach? Thanks in advance, Rich

 

 

 

  _____  

From: Gregory Williamson [mailto:Gregory.Williamson at digitalglobe.com] 
Sent: Tuesday, December 11, 2007 7:48 PM
To: Richard.Heimann at nrl.navy.mil; PostGIS Users Discussion; Michael
Smedberg; Richard.Heimann at nrl.navy.mil; PostGIS Users Discussion
Subject: RE: [postgis-users] HELP adding spatial field to table

 

I think it is rare that you'd want corrupt data. My usual approach has been
to load my data set into a temporary table (only lasts for the session (or
transaction)) and then apply sanity checks and either delete offending rows
or modify them if you know sane values to set them to.

Then create the geometries from the data set and insert it into my real
table, possibly with something like
  INSERT INTO some_real_table SELECT gid,label_name,the_geom FROM foo WHERE
IsValid(the_geom);

HTH,

Greg W.
(sorry for top-posting, challenged reader and pressed for time)

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net on behalf of Richard
Heimann [C]
Sent: Tue 12/11/2007 4:57 PM
To: 'Michael Smedberg'; Richard.Heimann at nrl.navy.mil; 'PostGIS Users
Discussion'
Subject: RE: [postgis-users] HELP adding spatial field to table

Thanks for the prompt response. And youre right there are some such values.
Is there a work around?

 Rich


-----Original Message-----
From: Michael Smedberg [mailto:Michael.Smedberg at redfin.com]
Sent: Tuesday, December 11, 2007 6:55 PM
To: Richard.Heimann at nrl.navy.mil; PostGIS Users Discussion
Subject: RE: [postgis-users] HELP adding spatial field to table

Are you sure that x and y always have legit values?  If one were null or
the zero-length string, I think you'd get an error like that.

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Richard Heimann [C]
Sent: Tuesday, December 11, 2007 3:44 PM
To: 'PostGIS Users Discussion'
Subject: [postgis-users] HELP adding spatial field to table

 All,

Im getting some strange behavior that I cant explain and sadly know its
likely trivial. My pursuit is simple, add a spatial filed to a table
containing x,y.

First. AddGeometryColumn

        SELECT AddGeometryColumn( 'crimetest', 'geom', 4326, 'POINT', 2)

Next (and where the trouble lies)

        UPDATE crimetest
        SET geom = PointFromText('POINT(' || x || ' ' || y || ')', 4326)

This is the error I receive.

ERROR: Invalid OGC WKT (too short)
SQL state: XX000
Context: SQL function "geomfromtext" statement 1
SQL function "pointfromtext" statement 1

Can anyone shed some light on this?


Thanks
Rich



_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users





_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071213/546a694d/attachment.html>