Saving map edits to local server

I have one more idea. There is a place in Rails port install, that I don't understand quite well.

Populating

To populate a PostgreSQL database using Osmosis from a planet file, do this: osmosis --read-xml-0.6 file="planet.osm.bz2" --write-apidb-0.6 populateCurrentTables=yes host="localhost" database="openstreetmap" user="openstreetmap" password="openstreetmap" validateSchemaVersion=no

Later updates to the database (sometimes referred to as the apidb) will need to use a change format (.osc).

You will need the latest Osmosis to have the right database scheme.

Troubleshooting database population
Running causes the error "Unable to create streaming resultset"

Run osmosis on the database "openstreetmap", e.g. use the command osmosis --rx file="planet.osm" --wd database="openstreetmap" user="openstreetmap" password="openstreetmap" Running causes the error "The database schema version of $1 does not match the expected version of $2"

Assuming that you are using osmosis with the 0.6 db, you can just add validateSchemaVersion=no to the --write-apidb params. Configuring Database to Write

If you intend to write to your database, you will need to reset the auto-increment sequences first (within postgres).

Note: Do this sequence twice, once for openstreetmap, once for osm.

I did not run this, as the idea is not clear for me. Can it be the root of my problem?

Ok, I've made this steps

1.sudo ./osmosis -q --replicate-apidb authFile=~osmosis/authFile.conf allowIncorrectSchemaVersion=true validateSchemaVersion=no --wr workingDirectory=/var/www/replication

2. ./osmosis --read-replication-interval workingDirectory=~/.osmosis/ --simplify-change --write-xml-change ~/.osmosis/changes.osc.gz

I can see my changes in xml format inside this file

1. osm2pgsql --append --slim changes.osc.gz

But I'm getting an error

:~/OSMOSIS/osmosis-0.41/bin$ osm2pgsql --append --slim .osmosis/changes.osc.gz osm2pgsql SVN version 0.81.0 (64bit id space)

Using projection SRS 900913 (Spherical Mercator) Setting up table: planet_osm_point NOTICE: table "planet_osm_point_tmp" does not exist, skipping Setting up table: planet_osm_line NOTICE: table "planet_osm_line_tmp" does not exist, skipping Setting up table: planet_osm_polygon NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping Setting up table: planet_osm_roads NOTICE: table "planet_osm_roads_tmp" does not exist, skipping 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=800MB, maxblocks=102401*8192, allocation method=11 Mid: pgsql, scale=100 cache=800 Setting up table: planet_osm_nodes PREPARE insert_node (int8, int4, int4, text[]) AS INSERT INTO planet_osm_nodes VALUES ($1,$2,$3,$4); PREPARE get_node (int8) AS SELECT lat,lon,tags FROM planet_osm_nodes WHERE id = $1 LIMIT 1; PREPARE delete_node (int8) AS DELETE FROM planet_osm_nodes WHERE id = $1; failed: ERROR: relation "planet_osm_nodes" does not exist LINE 1: ...rt_node (int8, int4, int4, text[]) AS INSERT INTO planet_osm... ^

Error occurred, cleaning up

There is really no table "planet_osm_nodes" in "gis" schema. Should it be there?