Skip to content

Latest commit

 

History

History
56 lines (36 loc) · 1.26 KB

README.md

File metadata and controls

56 lines (36 loc) · 1.26 KB
Raw

PostgREST Heroku

Run PostgREST on Heroku behind Nginx and Basic HTTP authentication.

Getting started

First, clone this repository:

git clone git@github.com:rhubarbgroup/postgrest-heroku.git

Next, create a new app on Heroku:

heroku create [APP] # --region=us --team=[TEAM]

heroku stack:set container

heroku addons:create heroku-postgresql:hobby-dev

heroku config:set AUTH_USER=picard
heroku config:set AUTH_PASS=Picard-Epsilon-7-9-3

Push the code to the Heroku repo:

git push heroku main

Now go test your PostgREST app:

heroku open

Configuration

The Heroku app will have the following Config Vars:

  • AUTH_USER: The basic auth user (default: admin)
  • AUTH_PASS: The basic auth password (default: password)
  • DATABASE_URL: The connection PostgreSQL URL
  • PGRST_DB_POOL: Number of connections to keep open in the pool (default: 10)
  • PGRST_DB_SCHEMA: The database schema to expose to REST clients (default public)

There is no DB_ANON_USER and DB_URI, we're using Heroku's DATABASE_URL.

Development

The docker-compose.yml can be used to run everything locally at http://localhost:8080/:

docker-compose up --build --force-recreate