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!
- installed PostgresSQL 9.5 or higher
- enabled PostGIS extension version 3.0 or higher
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.
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.