pigsty Docker & Self-Hosted Deployment

GitHub

Enterprise-Grade OSS PostgreSQL Distribution with HA, PITR, IaC, Monitor, 12 kernel forks and 500+ PG extensions. Best-of-breed products integrated as a...

5,323 stars Shell Shell 1 file · ~11,360 tokens #graphics#infra#postgres#service#toolbox#yours
RAW Compose
1. Pull Image (DOCKERHUB) docker pull postgrest/postgrest
2. Docker Run (1-Click Launch) docker run -d --name pigsty --restart always postgrest/postgrest
3. Podman Run podman run -d --name pigsty --restart always postgrest/postgrest
4. Skopeo Inspect (Zero-Pull Manifest) skopeo inspect docker://docker.io/postgrest/postgrest:latest
5. ORAS Pull (OCI Artifact) oras pull postgrest/postgrest
6. Compose Deployment docker compose up -d
app/postgrest/docker-compose.yml
Download .yml 
# check .env files before running

services:
  postgrest:
    container_name: postgrest
    image: postgrest/postgrest
    restart: always
    environment:
      PGRST_DB_URI        : ${POSTGREST_DB_URI}
      PGRST_DB_SCHEMA     : ${POSTGREST_DB_SCHEMA}
      PGRST_DB_ANON_ROLE  : ${POSTGREST_DB_ANON_ROLE}
      PGRST_SERVER_PORT   : ${POSTGREST_SERVER_PORT}
      PGRST_JWT_SECRET    : ${POSTGREST_JWT_SECRET}
    ports:
      - "${POSTGREST_SERVER_PORT}:${POSTGREST_SERVER_PORT}"