about summary refs log tree commit diff stats
path: root/tools/postgresql.html
diff options
context:
space:
mode:
authorSilvino Silva <silvino@bk.ru>2018-04-06 17:41:00 +0100
committerSilvino Silva <silvino@bk.ru>2018-04-06 17:41:00 +0100
commit8ee63f12e337f97013cfa3cb3d3b27f15f88dfcd (patch)
tree0ce231727fdbe28bc1ed64546be93f1ee988d7b6 /tools/postgresql.html
parent6bf0c99f1320e117663e34221837c6fe22f75e6f (diff)
parent152177eeca633a26a1228cfded025b5a7d861c66 (diff)
downloaddoc-8ee63f12e337f97013cfa3cb3d3b27f15f88dfcd.tar.gz
Release 0.3.3
Diffstat (limited to 'tools/postgresql.html')
-rw-r--r--tools/postgresql.html11
1 files 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>