Do you want to use MapTiler Server vector tiles generating on the fly feature 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
Comments
0 comments
Please sign in to leave a comment.