[OSM-dev] Release candidate for new osm2pgsql 0.88.0 stable release
We are preparing a new osm2pgsql stable series release, 0.88.0. This is based off of the work done in 0.87 development series with porting to C++. Help is needed in doing a last round of tests before release, in particular the z_order logic. 0.88.0-RC1 can be obtained from https://github.com/openstreetmap/osm2pgsql If upgrading from a 0.86.0 or earlier created database, the schema migrations in https://github.com/openstreetmap/osm2pgsql/blob/master/docs/migrations.md are required. Major changes = Osm2pgsql is now C++ and requires the Boost libraries. A new backend has been added, the “multi” backend. This allows multiple tables which can each contain different types of features. More documentation is available at https://github.com/openstreetmap/osm2pgsql/blob/master/docs/multi.md In-database pending way tracking has been replaced with in-memory tracking, offering significant performance gains. This requires a schema migration for old databases. z_order logic has been improved, taking into account recent work across multiple styles. https://github.com/openstreetmap/osm2pgsql/pull/374 has more information. This requires a schema migration for old databases. A diary post version of this is at http://osm.org/user/pnorman/diary/35369 ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Simplified osm2pgsql database dump available
To help with some OpenStreetMap carto development work, I've created a dump of the rendering tables with certain features removed, for testing at low zoom. This allows someone to load the database if using a machine incapable of importing the planet, and the dropped features cut the database size in half. It is available at http://tile.paulnorman.ca/planet-lz-150202.dump, but before downloading please read the notes below - Buildings without a name, amenity, shop, or similar tag have been removed - Residential roads have been removed - It comes with no indexes. To create the indexes, do CREATE INDEX ON planet_osm_point USING GIST (way) WITH (fillfactor = 100); CREATE INDEX ON planet_osm_line USING GIST (way) WITH (fillfactor = 100); CREATE INDEX ON planet_osm_polygon USING GIST (way) WITH (fillfactor = 100); CREATE INDEX ON planet_osm_roads USING GIST (way) WITH (fillfactor = 100); - Don't try to download this from your browser, as it is 26GB - I *will* be removing this dump from my server at some point. - The dump has been generated with pg_dump from PostgreSQL 9.4 in the pg_dump custom format. To get 9.4 on Debian or Ubuntu based systems, see https://wiki.postgresql.org/wiki/Apt - The dump is based on the planet dump from 150202 and is not current - The database size is about 50GB after loading ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev