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 ... :/ -- hartmut _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
