Osm2pgsql-replication update error planet_osm_point table does not exist


I am trying to update a postgis database previously imported with osm2pgsql using the osm2pgsql-replication feature but i get an error. I am using osm2pgsql version 1.8.0

What i have done:

  • imported from pbf file using this command:
    $osm2pgsqlCmd = “PGPASSWORD=$dbPassword osm2pgsql -c -d $dbName -H ‘db’ -U $dbUser -O flex -x -S $luaPath $pbfPath --slim”;
    This command create the relative table in my database, along with the ‘planet_osm_nodes’, ‘planet_osm_ways’ and ‘planet_osm_rels’ tables.

  • initialized the replication using this command:
    PGPASSWORD=$password osm2pgsql-replication init -d $database -H db -U $user
    this command creates a ‘planet_osm_replication_status’ table in my database with url, sequence and importdate columns needed for the update.

  • run the command for the update:
    PGPASSWORD=$passeord osm2pgsql-replication update -d $database -H db -U $user
    This throws error:
    ERROR: Database error: ERROR: relation “planet_osm_point” does not exist
    LINE 1: PREPARE get_wkb(int8) AS SELECT way FROM “planet_osm_point” …

Effectively i have no planet_osm_point table in my database because it was not created when importing from pbf.

What am i missing here?

Thanks for the attention :slight_smile:

4 posts - 3 participants

Read full topic

Ce sujet de discussion accompagne la publication sur https://community.openstreetmap.org/t/osm2pgsql-replication-update-error-planet-osm-point-table-does-not-exist/110924