[postgis-users] No Space left on device.

[Richard Heimann [C]]

Too easy!! Thanks again Paul.

 


-----Original Message-----
From: Paul Ramsey [mailto:pramsey at refractions.net] 
Sent: Thursday, December 13, 2007 11:23 AM
To: Richard.Heimann at nrl.navy.mil; PostGIS Users Discussion
Subject: Re: [postgis-users] No Space left on device.

Richard,

Move the "data" directory to a new device, and then in  
postgresql.conf, alter the location of the default data space to that  
location.

P

On 13-Dec-07, at 7:37 AM, Richard Heimann [C] wrote:

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