pg_featureserv quickstart

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

About pg_featureserv

From the pg_featureserv project:

A lightweight RESTful geospatial feature server for PostGIS, written in Go. It supports the OGC API - Features REST API standard.

pg_featureserv with container apps quickstart

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 your pg_featureserv, 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 PGFS_SERVER_HTTPPORT=5433 --privileged docker.io/pramsey/pg_featureserv:latest');
Copy

Now you can visit your running pg_featureserv at your 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>.