This extension for PostgreSQL implements Foreign Data Wrapper (FDW) for reading Openstreetmap PBF file format (*.osm.pbf)

* postgresql version => 10
* libprotobuf-c
* json-c >= 0.11
* zlib

sudo apt install libprotobuf-c-dev libprotobuf-c1 protobuf-c-compiler zlib1g-dev zlib1g libjson-c-dev libjson-c5 postgresql-server-dev-14
sudo make install

Install required packages before and next run:

sudo pgxn install osm_fdw

If you want to use not default version of postgres in your system, you can specify pg_config

sudo make PG_CONFIG=/usr/lib/postgresql/10/bin/pg_config install

Find more documentation here: osm_fdw doc

Find more examples here: examples

(Issues trackes) Email: v.pikulik@gmail.com

Vitali Pikulik v.pikulik@gmail.com