[Tile-serving] [OSM-talk] osm2pgsql import failed, no more space on device

[Paul Norman]

[moving to tile-serving@ because it's not a general talk@ question]

> From: Torsten Mohr [mailto:tmohr at s.netic.de]
> Sent: Friday, September 06, 2013 11:48 PM
> To: OpenStreetMap
> Subject: [OSM-talk] osm2pgsql import failed, no more space on device
> 
> Hello,
> 
> i have set up PostgresQL on a 480 Gb SSD, so there should be heaps of
> space for the database and the import.
> 
> The commented log of the import is at the end of this mail.
> 
> The import was running for less than a day and stopped sometime in the
> night.
> 
> I think --flat-nodes needs a parameter, but i'm not sure what to give
> there.
> But also, in another mail it was said it saves ~ 20Gb.

The flat nodes file is ~20GB. It saves probably closer to 100GB

The help (osm2pgsql -h -v) says

      --flat-nodes  Specifies the flat file to use to persistently store
node
                    information in slim mode instead of in PostgreSQL.

You need to give it a location to store the file. I suggest on the SSD for
faster updates.

> I can't imagine that 480 Gb is not enough, can anybody tell me what went
> wrong?

I am surprised you would hit a problem that early on. Re-reading the numbers
at http://lists.openstreetmap.org/pipermail/talk/2013-August/068108.html I
could see running out of space later in the import, but not this early on
(123m nodes in).

Could you double-check that the default postgres tablespace on the server is
on the SSD?