postgres_osm_pbf_fdw icon indicating copy to clipboard operation
postgres_osm_pbf_fdw copied to clipboard

OSM PBF Foreign Data Wrapper

OSM PBF Foreign Data Wrapper

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: [email protected]

Author

Vitali Pikulik [email protected]