[Tile-serving] [openstreetmap/osm2pgsql] Failed to create node cache file: Permission denied (#877)

[Nuno Pedrosa]

This is probably a dumb issue but I'm kind of stuck while trying to import a relatively big data set into an existing database `northamerica` with owner `northamerica`. More specifically, I'm getting a 'permission denied' error related with the creation of the node cache file. I wonder what I'm doing wrong? Here's what I'm typing into the command line:

`northamerica at map-server:/mnt/data$ osm2pgsql -c -d northamerica --slim -C 30000 --flat-nodes flatnodes.bin north-america-latest.osm.pbf`

Here's what I'm getting in return:

    osm2pgsql SVN version 0.88.1 (64bit id space)

    Using built-in tag processing pipeline
    Using projection SRS 900913 (Spherical Mercator)
    Setting up table: planet_osm_point
    Setting up table: planet_osm_line
    Setting up table: planet_osm_polygon
    Setting up table: planet_osm_roads
    Allocating memory for dense node cache
    Allocating dense node cache in one big chunk
    Allocating memory for sparse node cache
    Sharing dense sparse
    Node-cache: cache=30000MB, maxblocks=3840000*8192, allocation method=11
    Mid: loading persistent node cache from flatnode.bin
    Failed to create node cache file: Permission denied
    Error occurred, cleaning up

And here's the database:

<pre><font color="#A3BE8C"><b>northamerica at map-server</b></font>:<font color="#81A1C1"><b>/mnt/data</b></font>$ psql
psql (9.5.14)
Type "help" for help.

northamerica=# \d
                        List of relations
 Schema |             Name             |   Type   |    Owner     
--------+------------------------------+----------+--------------
 public | geography_columns            | view     | northamerica
 public | geometry_columns             | view     | northamerica
 public | lines                        | table    | northamerica
 public | lines_ogc_fid_seq            | sequence | northamerica
 public | multilinestrings             | table    | northamerica
 public | multilinestrings_ogc_fid_seq | sequence | northamerica
 public | multipolygons                | table    | northamerica
 public | multipolygons_ogc_fid_seq    | sequence | northamerica
 public | other_relations              | table    | northamerica
 public | other_relations_ogc_fid_seq  | sequence | northamerica
 public | points                       | table    | northamerica
 public | points_ogc_fid_seq           | sequence | northamerica
 public | raster_columns               | view     | northamerica
 public | raster_overviews             | view     | northamerica
 public | spatial_ref_sys              | table    | northamerica
(15 rows)

northamerica=# \l
                                      List of databases
     Name      |     Owner     | Encoding |   Collate   |    Ctype    |   Access privileges   
---------------+---------------+----------+-------------+-------------+-----------------------
 liechtenstein | liechtenstein | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 northamerica  | northamerica  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 postgres      | postgres      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0     | postgres      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
               |               |          |             |             | postgres=CTc/postgres
 template1     | postgres      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
               |               |          |             |             | postgres=CTc/postgres
(5 rows)
</pre>

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/877
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20181026/c8f361d5/attachment.html>