[OSM-dev] speeding up loading an OSM dump into PostGIS?

Hartmut Holzgraefe hartmut.holzgraefe at gmail.com
Fri Dec 16 10:09:33 GMT 2011

On 15.12.2011 12:10, Frederik Ramm wrote:

> But: Anyone who really wants to, and has the resources to, can set up a
> full database today, feed it with minutely diffs through Osmosis, and
> allow a merry band of replication clients down the line.

problem is that Postgres repliation (the bundled one in 9.0+) replicates
physical pages and page deltas and the exact page format is architecture
dependant. So you can only replicate between systems that share the same
byte order, integer size, maybe even same C compiler padding ...

(unlike MySQL that logs logical changes into its replication log in a
portable format and even has architecture agnostic physical storage
formats for most storage engines so that moving logs or even complete
data directory snapshots between different architectures has been a
no-brainer ever since MySQL 3.23 ...)

So even a public PG replication master would only make sense for those
who run exactly the same architecture, or multiple masters for
different architectures would be needed ... :/


More information about the dev mailing list