This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

Osmosis ERROR: relation “replication_changes” does not exist

0

I upgraded Osmosis to 0.48 did a full planet import to Postgres and started the syncing process. I used the same command I used with Osmosis 0.47; however, I am getting an error.

org.postgresql.util.PSQLException: ERROR: relation "replication_changes" does not exist

This is the command I executed:

/usr/share/osmosis-0.48.2/bin/osmosis --read-replication-interval workingDirectory=. --simc --write-pgsql-change host="127.0.0.1" database="osm" user="my_user" password='my_pass'

I never got this error before (I've been doing the syncing for the past 2-3 years.) Couldn't find any information regarding a table called replication_changes when googled. This is the table fields reported by the error:

replication_changes (nodes_added, nodes_modified, nodes_deleted, ways_added, ways_modified, ways_deleted, relations_added, relations_modified
, relations_deleted, changesets_applied, earliest_timestamp, latest_timestamp)

asked 26 Sep '20, 14:44

picmate's gravatar image

picmate
714610
accept rate: 50%


One Answer:

0

You need to apply .../osmosis/script/pgsnapshot_schema_0.6_changes.sql by psql command. This will create a TABLE replication_changes.

answered 23 Oct '21, 19:18

nichtgedacht's gravatar image

nichtgedacht
1
accept rate: 0%

Source code available on GitHub .