OSM PBF Foreign Data Wrapper

October 14, 2021 ยท View on GitHub

Introduction

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

Requirements

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

Install

How to install in Debian 11

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 with PGXN

Install required packages before and next run:

sudo pgxn install osm_fdw

Addition parameters

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

Documentation

Find more documentation here: osm_fdw doc

Examples

Find more examples here: examples

Support

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

Author

Vitali Pikulik v.pikulik@gmail.com