Skip to content

Latest commit

 

History

History
27 lines (21 loc) · 1.14 KB

README.md

File metadata and controls

27 lines (21 loc) · 1.14 KB
Raw

Requirements

  1. Server with caprover installed and ready to go
  2. Postgres database on that server (one-click apps rock!)
  3. A google cloud storage bucket with versioning enabled

Usage

  1. Create a caprover app.
  2. Check "Do not expose as web-app"
  3. Specify the following environment variables in the App Configs tab (example)
    • BUCKET_PATH - The gs://<bucket>/<filename>.tar.zst path to the GCS bucket where the db backup should be stored
    • GOOGLE_APPLICATION_CREDENTIALS_JSON - A JSON service account key, that has permission to create/replace objects in above bucket.
    • PGHOST, PGPORT, PGUSER, PGPASSWORD - Should point to your db
  4. Add this github repo in the deployment tab, press force deploy

Restore

Reference: https://www.postgresql.org/docs/current/continuous-archiving.html

  1. Exec into a new container that is running the postgres image
  2. Make sure that $PGDATA is empty
  3. Run this script to download the backup and untar it into the $PGDATA directory
gsutil cp gs://<bucket>/<filename>.tar.zst - | tar -I zstd -xvf - -C $PGDATA
  1. pg_ctl -D $PGDATA reload