diff options
| -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 |