pg_tileserv Quickstart

This quickstart guide will help you get pg_tileserv up and running with Container Apps on Crunchy Bridge. We recommend you start with the Container Apps Quickstart to get a general understanding of Container Apps.

About pg_tileserv

From the pg_tileserv project:

A PostGIS-only tile server in Go. Strip away all the other requirements, it just has to take in HTTP tile requests and form and execute SQL. In a sincere act of flattery, the API looks a lot like that of the Martin tile server.

Getting started with pg_tileserv in a Container App

First, make sure you have Container Apps enabled. As a user with superuser privileges, run CREATE EXTENSION pgpodman; to install the extension in the postgres database of the desired cluster.

Next, find your cluster’s database URL to include as the DATABASE_URL parameter when you run the container. You can find the URL in the Connection section of the cluster dashboard (choose the application role), or by running cb uri --role application <cluster name> on the command line.

To start pg_tileserv, run the following using your own value for DATABASE_URL:

SELECT run_container('-dt -p 5433:5433/tcp -e DATABASE_URL="your-database-URL" -e TS_HTTPPORT=5433  docker.io/pramsey/pg_tileserv:latest');

Now you can visit your running pg_tileserv at your-host-URL:5433. You can find your Host URL in the Overview section of your cluster dashboard, or by running cb info <cluster name>.