macOS
Homebrew已验证 · 100%
brew install osm2pgsqllocal Homebrew formula metadata
MacPorts已验证 · 94%
sudo port install osm2pgsqlMacPorts ports tree · gis/osm2pgsql/Portfile · 来源: api.github.com
安装
其他安装命令
Linux
Debian apt已验证 · 92%
sudo apt install osm2pgsqlDebian stable package indexes · osm2pgsql · 来源: deb.debian.org
Fedora dnf已验证 · 92%
sudo dnf install osm2pgsqlFedora Rawhide package metadata · osm2pgsql · 来源: dl.fedoraproject.org
Nix已验证 · 92%
nix profile install nixpkgs#osm2pgsqlnixpkgs package indexes · pkgs/by-name/os/osm2pgsql/package.nix · 来源: api.github.com
Arch Linux pacman已验证 · 92%
sudo pacman -S osm2pgsqlArch Linux sync databases · osm2pgsql · 来源: geo.mirror.pkgbuild.com
概览
软件包摘要
OpenStreetMap data to PostgreSQL converter
历史
项目历史与用法
osm2pgsql is one of the central OpenStreetMap data-ingestion tools. It imports OSM data into PostgreSQL/PostGIS, where renderers, geocoders, analysis jobs, and custom SQL pipelines can work with planet-scale map data.
项目历史
The osm2pgsql project began in 2006, started by Jon Burgess and written in C, making it nearly as old as OpenStreetMap itself. In 2007, after OSM moved to API 0.5 and added relations, osm2pgsql gained multipolygon relation support and multiple projection support.
In 2008, osm2pgsql added support for OSM change files. From 2009, the main OpenStreetMap map was regenerated from minutely changes using a toolchain that imported data with osm2pgsql into PostgreSQL/PostGIS and rendered tiles with Mapnik.
The project kept following OSM's growth. In 2011, it switched to 64-bit IDs as the OSM node count passed one billion, and Kai Krueger took over maintainership from Jon Burgess. In 2012, the flat-file persistent node cache for slim mode reduced disk usage and improved import/update performance.
A long modernization arc followed: parsing moved to libosmium in 2015, geometry generation moved to libosmium in 2017, LuaJIT support arrived in 2018, version 1.0 in 2019 removed old-style multipolygon processing, and the flex output introduced in 2020 made custom output-table design a first-class workflow.
The 2022 experimental `osm2pgsql-gen` command brought generalization into the project. In 2023, a JSONB-based middle database format made it possible to store all OSM data including tags, attributes, and relation-member information. In 2024, Nominatim switched to flex output, the old gazetteer output was removed, and osm2pgsql 2.0 shipped.
采用历史
osm2pgsql became deeply embedded because it solved the hard practical problem of keeping PostgreSQL/PostGIS databases synchronized with OSM data at rendering scale. The project history explicitly ties it to the OpenStreetMap tile toolchain and to Nominatim, the geocoder powering search on openstreetmap.org and many other map sites.
The GitHub repository passed 1,000 stars in 2021 according to the project's own history page. The Homebrew formula and package-manager metadata show distribution through Homebrew, Debian, Fedora, MacPorts, Nix, Arch, Ubuntu, and openSUSE-family packaging.
使用方式
The manual describes osm2pgsql as a specialized ETL tool for OSM data. Users usually feed it regional extracts or planet files, tune memory and disk behavior, choose pgsql or flex output, and then connect downstream software for rendering, serving, geocoding, or analysis.
The manual also warns that whole-planet imports can run for hours or days and recommends trial runs on small extracts. That operational reality is part of osm2pgsql's identity: it is not just a converter, but a tool whose schema, cache, update, and style choices determine the shape and cost of an OSM database.
为什么软件包爱好者会关心
osm2pgsql is package-nerd gold because it sits at the junction of C++, libosmium, Lua/LuaJIT, PostgreSQL, PostGIS, and large public datasets. Small version changes can affect import speed, schema output, multipolygon behavior, replication workflows, and downstream projects such as Nominatim or map renderers.
Its history also mirrors the OpenStreetMap ecosystem's scaling story: from early XML imports, through minutely updates and 64-bit IDs, into flexible Lua-defined outputs and JSONB-backed middle storage.
时间线
- 2006: Jon Burgess starts osm2pgsql in C.
- 2007: relation, multipolygon, and projection support expand after OSM API 0.5.
- 2008-2009: change-file support enables minutely-update rendering workflows.
- 2009: Nominatim begins using osm2pgsql with special gazetteer output.
- 2011: 64-bit IDs land, and Kai Krueger becomes maintainer.
- 2012: the flat-file persistent node cache improves slim-mode import and update performance.
- 2015-2017: libosmium takes over parsing and geometry generation.
- 2019-2020: version 1.0 and flex output modernize the processing pipeline.
- 2022-2024: generalization, JSONB middle storage, Nominatim's flex-output migration, and osm2pgsql 2.0 reshape the project.
Related projects
- PostgreSQL and PostGIS are the target database stack. Mapnik is historically tied to the OSM tile-rendering toolchain. Nominatim uses osm2pgsql-derived import paths for geocoding data. libosmium underpins OSM parsing and geometry handling in modern osm2pgsql.
来源
安全态势
风险级别：yellow
broad file, network, media, or database tool signal. generalized runtime or code generation signal.
风险分类器
yellow 风险 · 中 置信度 · runtime
原因
- broad file, network, media, or database tool signal
- generalized runtime or code generation signal
信号
- text:repl
- text:sql
安装行为
- 未记录 Homebrew bottle 元数据。
建议审查
在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。
可执行文件
已安装的可执行文件
| 命令 | 类型 | 暴露范围 | 备注 |
|---|---|---|---|
osm2pgsql | 可执行文件 | 已索引可执行文件 | 从本地可执行文件索引发现。 |
osm2pgsql-expire | 可执行文件 | 已索引可执行文件 | 从本地可执行文件索引发现。 |
osm2pgsql-replication | 可执行文件 | 已索引可执行文件 | 从本地可执行文件索引发现。 |
新鲜度
版本和新鲜度
这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。
页面生成时间2026-08-03
管理器版本2.3.1
管理器更新时间2026-07-05
本地数据未知
上游不可用
检测到的最新版本未检测到
- OK没有生成新鲜度警告。
安装元数据
软件包元数据
| 软件包键 | brew:osm2pgsql |
|---|---|
| 版本 | 2.3.1 |
| 软件包管理器 | Homebrew |
| 主页 | https://osm2pgsql.org |
| 仓库 | https://github.com/osm2pgsql-dev/osm2pgsql |
| 最后更新 | 2026-07-05T16:19:51Z |
| Pulse | updated |
| Bottle | 未记录 |
| 服务 | 未声明 |
源数据库匹配
其他软件包管理器记录
匹配项来自外部软件包管理器索引，并与本地 Automic Vault 软件包链接分开显示。
Debian apt95%
osm2pgsql 2.1.1+ds-1
OpenStreetMap data to PostgreSQL converter
sudo apt install osm2pgsql- Section: utils
- Architecture: amd64
- 16 依赖
- 1 可选依赖
- normalized package name match
- 匹配方式：Osm2pgsql
Nix95%
osm2pgsql
nix profile install nixpkgs#osm2pgsql- normalized package name match
- 匹配方式：Osm2pgsql
Ubuntu apt95%
osm2pgsql 1.11.0+ds-1
OpenStreetMap data to PostgreSQL converter
sudo apt install osm2pgsql- Section: universe/utils
- Architecture: amd64
- 13 依赖
- 1 可选依赖
- normalized package name match
- 匹配方式：Osm2pgsql
dnf95%
osm2pgsql 2.3.1-2.fc45
Import map data from OpenStreetMap to a PostgreSQL database
sudo dnf install osm2pgsql- License: GPL-2.0-or-later
- Category: Unspecified
- Architecture: x86_64
- Source Package: osm2pgsql
- 12 依赖
- 1 提供
- normalized package name match
- 匹配方式：Osm2pgsql
pacman95%
osm2pgsql 2.3.1-1
tool for loading OpenStreetMap data into a PostgreSQL / PostGIS database
sudo pacman -S osm2pgsql- License: GPL-2.0-only
- Architecture: x86_64
- 8 依赖
- 2 可选依赖
- normalized package name match
- 匹配方式：Osm2pgsql
MacPorts95%
osm2pgsql
sudo port install osm2pgsql- normalized package name match
- 匹配方式：Osm2pgsql
来源线索
由仓库数据生成
此页面由 av-web 从 scripts/generate-pkg-sqlite.py 生成的私有软件包 SQLite 工件提供。
Combined YAML source
View the package source record on GitHub.
使用的来源
- Geiger risk classifier
- cross-ecosystem install command graph
- curated package history
- external package-manager database matches
- pkg.so package database
- pkgdb category and tag curation