| title | Community Documentation |
|---|
There are some osm2pgsql developers and users who have written up howtos or blog posts, gave talks, filmed tutorials etc. Not all of that is up to date with current version of the software and recommended usage, but there is a lot to learn there.
See also the osm2pgsql page{:.extlink} on the OSM wiki.
- The developer Jochen Topf writes occasionally about osm2pgsql in his blog{:.extlink}.
- Ryan Lambert of RustProof Labs has a blog{:.extlink} with lots of osm2pgsql content.
- Jakob Miksch has a blog{:.extlink} with some posts related to osm2pgsql.
- Martijn van Exel has a blog post about Keeping a thematic OpenStreetMap database up-to-date with osm2pgsql{:.extlink}.
- Mathias Gröbe has a complete flex config with matching QGIS config file{:.extlink}.
- The CrunchyData blog explores how to do quick imports: Loading the World! OpenStreetMap Import In Under 4 Hours{:.extlink}.
- Marcos Dione: Bus routes with osm2pgsql flex backend{:.extlink}.
- Martijn van Exel: ETL With OpenStreetMap: Simple Things Are Simple, But Then What?.
- PgOSM Flex provides a curated set of Lua and SQL scripts to clean and organize the most commonly used OpenStreetMap data, such as roads, buildings, and points of interest (POIs).
- From FOSSGIS 2026: "Aufbau und Aktualisierung einer OSM-basierten Karten mit osm2pgsql" by Mathias Gröbe (in German). Slides{:.extlink}, Video on media.ccc.de{:.extlink}, Video on YouTube{:.extlink} (March 2026).
- From PostGIS Day 2025: "Getting OpenStreetMap Data In PostGIS With osm2pgsql" by Jochen Topf. Slides{:.extlink}, Video Download{:.extlink}, Video on YouTube{:.extlink} (November 2025).
- From FOSSGIS 2024: "osm2pgsql - OSM Daten mit PostGIS verarbeiten" by Jakob Miksch (in German). Slides{:.extlink}, Video on media.ccc.de{:.extlink}, Video on YouTube{:.extlink} (March 2024).
- From SOTM-EU 2023: "Modern osm2pgsql tricks" by Paul Norman and Jochen Topf Video on YouTube{:.extlink} (November 2023).
- From PostGIS Day 2022: "Route the Interesting Things (Not Just Roads!) with OpenStreetMap" by Ryan Lambert Video on YouTube{:.extlink} (December 2022).
- From PostGIS Day 2022: "Speedrunning the Open Street Map osm2pgsql Loader" by Greg Smith Video on YouTube{:.extlink} (December 2022).
- From SotM 2021: "News from osm2pgsql" by Jochen Topf. Slides{:.extlink}, Download Video{:.extlink}, Video on YouTube{:.extlink} (July 2021).
- From FOSSGIS 2021: "Neues von osm2pgsql" by Jochen Topf (in German). Slides{:.extlink}, Download Video{:.extlink}, Video on YouTube{:.extlink} (June 2021).
- From SotM 2019: "OSM data processing with PostgreSQL/PostGIS" by Jochen Topf. Slides{:.extlink}, Download Video{:.extlink}, Video on YouTube{:.extlink} (September 2019).
- From SotM-US 2014: "osm2pgsql:mapnik — Optimizing the Rendering Toolchain" by Paul Norman. Video on YouTube{:.extlink}.
- Thomas Skowron writes about Keeping your OpenStreetMap Database Replicated{:.extlink} (April 2025).
- Book Mastering PostGIS and OpenStreetMap{:.extlink} by Ryan Lambert (released October 2022).
- Webinar OpenStreetMap to PostGIS: Easier and Better!{:.extlink} by Ryan Lambert (March 2021).
- A video webinar in 6 parts: Intro to PostGIS and OpenStreetMap{:.extlink} by Ryan Lambert (January 2020).