NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

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%


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

permanent link

answered 23 Oct '21, 19:18

nichtgedacht's gravatar image

nichtgedacht
1
accept rate: 0%

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×252
×165
×134

question asked: 26 Sep '20, 14:44

question was seen: 1,249 times

last updated: 23 Oct '21, 19:18

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum