OSM2PGSQL-REPLICATION(1) OSM2PGSQL-REPLICATION(1) (NAME) osm2pgsql-replication - osm2pgsql (SYNOPSIS) osm2pgsql-replication [-h] {init,update,status} ... (DESCRIPTION) osm2pgsql (replication) (OSM). (import) . . . osm2pgsql-replication 'init' 'update' . (AVAILABLE COMMANDS) ?Bosm2pgsql-replication?R ?Iinit?R . ?Bosm2pgsql-replication?R ?Iupdate?R . ?Bosm2pgsql-replication?R ?Istatus?R JSON. ?I'osm2pgsql-replication init'?R usage: osm2pgsql-replication init [-h] [-q] [-v] [-d DB] [-U NAME] [-H HOST] [-P PORT] [-p PREFIX] [--middle-schema SCHEMA] [--schema SCHEMA] [--osm-file FILE | --server URL] [--start-at TIME] . . . (rollback) . . . ( osm2pgsql 1.9 ) . openstreetmap.org . (timestamp) ( osm2pgsql 1.9 ) (way) API OSM . '--server' . '--start-at' ISO ( 2007-08-20T12:21:53Z) . . '--start-at' . . OSM . 'osm2pgsql-replication --osm-file ' . ?I'osm2pgsql-replication init'?R ?B-q?R, ?B--quiet?R ?B-v?R, ?B--verbose?R ?I'osm2pgsql-replication init'?R osm2pgsql . libpq https://www.postgresql.org/docs/current/libpq-envars.html . pgpass https://www.postgresql.org/docs/current/libpq-pgpass.html . ?B-d?R ?IDB?R, ?B--database?R ?IDB?R PostgreSQL conninfo ?B-U?R ?INAME?R, ?B--username?R ?INAME?R, ?B--user?R ?INAME?R PostgreSQL ?B-H?R ?IHOST?R, ?B--host?R ?IHOST?R ?B-P?R ?IPORT?R, ?B--port?R ?IPORT?R ?B-p?R ?IPREFIX?R, ?B--prefix?R ?IPREFIX?R ( 'planet_osm') ?B--middle-schema?R ?ISCHEMA?R ?B--schema?R ?ISCHEMA?R ?I'osm2pgsql-replication init'?R ?B--osm-file?R ?IFILE?R . ?B--server?R ?IURL?R URL ?B--start-at?R ?ITIME?R . ( ISO) . . ?I'osm2pgsql-replication update'?R usage: osm2pgsql-replication update update [options] [-- param [param ...]] . '--max-diff-size' . osm2pgsql . '--diff-file' . 0 . osm2pgsql '--' . osm2pgsql . '--append' '--slim' . '--post-processing' osm2pgsql . osm2pgsql . (post-processing) . 'update' (diffs) . . : (sequence ID) . . ?Bparam?R osm2pgsql. ?I'osm2pgsql-replication update'?R ?B--diff-file?R ?IFILE?R osm2pgsql. ?B--max-diff-size?R ?IMAX_DIFF_SIZE?R (: 500MB) ?B--osm2pgsql-cmd?R ?IOSM2PGSQL_CMD?R osm2pgsql ?B--once?R . ?B--post-processing?R ?ISCRIPT?R osm2pgsql. ?I'osm2pgsql-replication update'?R ?B-q?R, ?B--quiet?R ?B-v?R, ?B--verbose?R ?I'osm2pgsql-replication update'?R osm2pgsql . libpq https://www.postgresql.org/docs/current/libpq-envars.html . pgpass https://www.postgresql.org/docs/current/libpq-pgpass.html . ?B-d?R ?IDB?R, ?B--database?R ?IDB?R PostgreSQL conninfo ?B-U?R ?INAME?R, ?B--username?R ?INAME?R, ?B--user?R ?INAME?R PostgreSQL ?B-H?R ?IHOST?R, ?B--host?R ?IHOST?R ?B-P?R ?IPORT?R, ?B--port?R ?IPORT?R ?B-p?R ?IPREFIX?R, ?B--prefix?R ?IPREFIX?R ( 'planet_osm') ?B--middle-schema?R ?ISCHEMA?R ?B--schema?R ?ISCHEMA?R ?I'osm2pgsql-replication status'?R usage: osm2pgsql-replication status [-h] [-q] [-v] [-d DB] [-U NAME] [-H HOST] [-P PORT] [-p PREFIX] [--middle-schema SCHEMA] [--schema SCHEMA] [--json] JSON. : 2021-08-17 15:20:28 [INFO]: Using replication service 'https://planet.openstreetmap.org/replication/minute', which is at sequence 4675115 ( 2021-08-17T13:19:43Z ) 2021-08-17 15:20:28 [INFO]: Replication server's most recent data is <1 minute old 2021-08-17 15:20:28 [INFO]: Local database is 8288 sequences behind the server, i.e. 5 day(s) 20 hour(s) 58 minute(s) 2021-08-17 15:20:28 [INFO]: Local database's most recent data is 5 day(s) 20 hour(s) 59 minute(s) old '--json' JSON : { "server": { "base_url": "https://planet.openstreetmap.org/replication/minute", "sequence": 4675116, "timestamp": "2021-08-17T13:20:43Z", "age_sec": 27 }, "local": { "sequence": 4666827, "timestamp": "2021-08-11T16:21:09Z", "age_sec": 507601 }, "status": 0 } 'status' 0 1 2 3 . 0 'error' ( ) . 'status' . 'server' 'sequence' 'timestamp' 'age_sec' . 'local' . ?I'osm2pgsql-replication status'?R ?B--json?R JSON. ?I'osm2pgsql-replication status'?R ?B-q?R, ?B--quiet?R ?B-v?R, ?B--verbose?R ?I'osm2pgsql-replication status'?R osm2pgsql . libpq https://www.postgresql.org/docs/current/libpq-envars.html . pgpass https://www.postgresql.org/docs/current/libpq-pgpass.html . ?B-d?R ?IDB?R, ?B--database?R ?IDB?R PostgreSQL conninfo ?B-U?R ?INAME?R, ?B--username?R ?INAME?R, ?B--user?R ?INAME?R PostgreSQL ?B-H?R ?IHOST?R, ?B--host?R ?IHOST?R ?B-P?R ?IPORT?R, ?B--port?R ?IPORT?R ?B-p?R ?IPREFIX?R, ?B--prefix?R ?IPREFIX?R ( 'planet_osm') ?B--middle-schema?R ?ISCHEMA?R ?B--schema?R ?ISCHEMA?R (SEE ALSO) * osm2pgsql (https://osm2pgsql.org) * osm2pgsql (https://osm2pgsql.org/doc/manual.html) 2.3.1 OSM2PGSQL-REPLICATION(1)