Prepare your Postgres for MapTiler Server

Do you want to use MapTiler Server vector tiles generating on the flyfeature and you wonder how to set up your Postgres database? In this article, we will show how!

Installation

• installed PostgresSQL 9.5 or higher
• enabled PostGIS extension version 3.0 or higher
  • For native installation please see the official tutorial targeting your platform https://postgis.net/install/
  • If you do not have any running database, the easiest way to start is with Postgis docker image: https://hub.docker.com/r/postgis/postgis

MapTiler Server serves vector tiles gziped. If you enable gzip extension in your database, tiles will leave your database compressed. This may reduce network traffic between your database and Server.

Common issues

MapTiler Server uses public.geometry_columns view and relies on correct geometry columns initialization. In practice, geometry columns are often created without proper SRID. MapTiler Server will inform you about this inconsistency and provide a dialog to help you set the correct SRID.

Useful links

How to import spatial data to PostGIS for MT Server
Vector tiles from PostgreSQL
Advanced SQL editing