diff options
| author | supahgreg <supahgreg@users.noreply.github.com> | 2025-10-14 11:49:48 +0000 |
|---|---|---|
| committer | supahgreg <supahgreg@users.noreply.github.com> | 2025-10-14 11:49:48 +0000 |
| commit | e02f7d98da16a8257d6b8db72e01063b82e55d39 (patch) | |
| tree | dedd38da06a4b0265cd24d217c4d43c65f0f9dfe /Installation-Guide.md | |
| parent | f18a8503f648e46d91c4d842f59c55734372d32b (diff) | |
Add an example of backing up a PostgreSQL 18 DB.
Diffstat (limited to 'Installation-Guide.md')
| -rw-r--r-- | Installation-Guide.md | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/Installation-Guide.md b/Installation-Guide.md index 4d4da6e..72f12d3 100644 --- a/Installation-Guide.md +++ b/Installation-Guide.md @@ -454,6 +454,18 @@ docker compose exec db /bin/bash \ -c "export PGPASSWORD=$TTRSS_DB_PASS \ && pg_dump -U $TTRSS_DB_USER $TTRSS_DB_NAME" \ | gzip -9 > backup.sql.gz + +# NOTE: The 'backup' container uses the PostgreSQL 17 client, and isn't currently compatible with PostgreSQL 18+. +# Something like the following could be ran (typically from your Docker Compose directory) to back up a PostgreSQL 18 DB. +source .env +docker run --rm \ + --network "${COMPOSE_PROJECT_NAME:-$(basename "$PWD")}_default" \ + -e PGPASSWORD="$TTRSS_DB_PASS" \ + postgres:18-alpine pg_dump \ + -h "${TTRSS_DB_HOST:-db}" \ + -U "$TTRSS_DB_USER" \ + "$TTRSS_DB_NAME" | gzip > backup.sql.gz + ``` #### Restoring backups |