From 73eddbd1550e8573d9d7b31860b75f007de73da8 Mon Sep 17 00:00:00 2001
From: Silvino Silva <silvino@bk.ru>
Date: Tue, 6 Mar 2018 15:57:00 +0000
Subject: tools fix postgresql backup

---
 tools/postgresql.html | 11 +++++++----
 1 file changed, 7 insertions(+), 4 deletions(-)

diff --git a/tools/postgresql.html b/tools/postgresql.html
index 0399ec6..155f30c 100644
--- a/tools/postgresql.html
+++ b/tools/postgresql.html
@@ -300,15 +300,18 @@
         db_flyspray=# create schema public;
         </pre>
 
-        <h3 id="backup">7.4. Backup</h3>
+        <h2 id="backup">8. Backup</h3>
 
+        <h3>8.1. Dump databases</h3>
 
-        <p>Backup Database</p>
+        <pre>
+        $ pg_dumpall -U postgres | gzip > cluster_dump.gz
+        </pre>
 
-        <h3 id="backup">7.5. Restore</h3>
+        <h3>8.2. Restore</h3>
 
         <pre>
-        $ psql db_flyspray &lt; database_dump
+        $ gzip -c cluster_dump.gz | psql -U postgres 
         </pre>
 
         <a href="index.html">Tools Index</a>
-- 
cgit 1.4.1-2-gfad0