Self-host pgweb

copy# pgweb — PostgreSQL browser, next to a throwaway PostgreSQL — pinned to 0.17.0
echo "DB_PASSWORD=$(openssl rand -hex 12)" > .env
echo "PGWEB_PASSWORD=$(openssl rand -hex 12)" >> .env
cat > docker-compose.yml <<'EOF'
services:
  pgweb:
    image: sosedoff/pgweb:0.17.0
    restart: unless-stopped
    ports:
      - 8081:8081
    environment:
      PGWEB_DATABASE_URL: postgres://postgres:${DB_PASSWORD}@db:5432/postgres?sslmode=disable
      PGWEB_AUTH_USER: admin
      PGWEB_AUTH_PASS: ${PGWEB_PASSWORD}
    depends_on:
      db:
        condition: service_healthy
  db:
    image: postgres:17
    restart: unless-stopped
    environment:
      POSTGRES_PASSWORD: ${DB_PASSWORD}
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U postgres"]
      interval: 3s
      timeout: 3s
      retries: 20
    volumes:
      - db_data:/var/lib/postgresql/data
volumes:
  db_data:
EOF
docker compose up -d
timeout 120 bash -c 'until curl -fsS -u "admin:$(grep PGWEB_PASSWORD .env | cut -d= -f2)" http://localhost:8081/ >/dev/null; do sleep 3; done'
# → http://SERVER_IP:8081 — HTTP basic auth: admin and the PGWEB_PASSWORD in .env