Files
plane/.gitea/workflows/build-and-deploy.yml
T
carlandClaude Opus 4.7 9cb5660e0b
Build & deploy v1.3.1-custom / Build & deploy (push) Successful in 6m47s
fix(ci): pg_dump via local Unix socket to bypass password auth
docker compose exec -T plane-db pg_dump without -h goes through TCP
plane-db:5432, which requires PGPASSWORD. Using -h /var/run/postgresql
hits the local socket, which has trust auth in the postgres image.

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
2026-05-22 01:45:21 +08:00

101 lines
3.3 KiB
YAML

name: Build & deploy v1.3.1-custom
on:
push:
branches:
- v1.3.1-custom
workflow_dispatch:
concurrency:
group: deploy-plane-prod
cancel-in-progress: false
env:
COMPOSE_PROJECT_NAME: community
COMPOSE_FILE: deployments/cli/community/docker-compose.yml:.gitea/docker-compose.override.yml
BACKUP_DIR: /opt/plane-backups
KEEP_BACKUPS: "5"
jobs:
deploy:
name: Build & deploy
runs-on: srv1563674
steps:
- name: Checkout
uses: actions/checkout@v4
- name: Show context
run: |
set -euo pipefail
echo "commit: ${GITHUB_SHA}"
echo "branch: ${GITHUB_REF_NAME}"
echo "cwd: $(pwd)"
docker --version
docker compose version
- name: Materialize .env from PROD_ENV_FILE secret
env:
PROD_ENV_FILE: ${{ secrets.PROD_ENV_FILE }}
run: |
set -euo pipefail
if [ -z "${PROD_ENV_FILE:-}" ]; then
echo "FATAL: Gitea repo secret PROD_ENV_FILE is missing."
echo "Set it to the full production .env content (POSTGRES_PASSWORD, SECRET_KEY, etc.)."
exit 1
fi
printf '%s\n' "$PROD_ENV_FILE" > .env
chmod 600 .env
SHORT_SHA="${GITHUB_SHA:0:8}"
if grep -q "^PLANE_IMAGE_TAG=" .env; then
sed -i "s/^PLANE_IMAGE_TAG=.*$/PLANE_IMAGE_TAG=${SHORT_SHA}/" .env
else
echo "PLANE_IMAGE_TAG=${SHORT_SHA}" >> .env
fi
echo "PLANE_IMAGE_TAG -> ${SHORT_SHA}"
echo ".env: $(wc -l < .env) lines, $(wc -c < .env) bytes"
- name: Validate compose config
run: docker compose config --quiet
- name: pg_dump backup (rotate keep ${KEEP_BACKUPS})
run: |
set -euo pipefail
mkdir -p "$BACKUP_DIR"
SHORT_SHA="${GITHUB_SHA:0:8}"
TS=$(date -u +%Y%m%dT%H%M%SZ)
BAK="$BACKUP_DIR/${SHORT_SHA}-${TS}.sql.gz"
# -h /var/run/postgresql uses the local Unix socket, which has trust
# auth in the official postgres image — so no PGPASSWORD needed.
docker compose exec -T plane-db pg_dump -U plane -h /var/run/postgresql plane | gzip > "$BAK"
test -s "$BAK"
ls -1t "$BACKUP_DIR"/*.sql.gz | tail -n +$((KEEP_BACKUPS + 1)) | xargs -r rm -f
echo "wrote $(du -h "$BAK" | cut -f1) -> $BAK"
- name: Build Plane images (web/admin/space/api/live/proxy)
run: docker compose build
- name: Run migrator (one-shot DB migrations)
run: docker compose run --rm migrator
- name: Recreate containers (keep plane-ai/dashboard untouched)
run: docker compose up -d
- name: Status
run: docker ps --filter "label=com.docker.compose.project=community" --format "table {{.Names}}\t{{.Status}}\t{{.Image}}"
- name: Health check (proxy on 8090)
run: |
set -euo pipefail
sleep 5
for i in $(seq 1 30); do
if curl -fsS -m 5 -o /dev/null http://localhost:8090/; then
echo "proxy health OK"
exit 0
fi
echo "waiting for proxy ($i/30)..."
sleep 2
done
echo "FAIL: proxy didn't come back. Current containers:"
docker ps --filter "label=com.docker.compose.project=community" --format "table {{.Names}}\t{{.Status}}\t{{.Image}}"
exit 1