From e02f7d98da16a8257d6b8db72e01063b82e55d39 Mon Sep 17 00:00:00 2001
From: supahgreg <supahgreg@users.noreply.github.com>
Date: Tue, 14 Oct 2025 11:49:48 +0000
Subject: Add an example of backing up a PostgreSQL 18 DB.

---
 Installation-Guide.md | 12 ++++++++++++
 1 file changed, 12 insertions(+)

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
-- 
cgit v1.2.3-54-g00ecf