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:43:58 +0100
committerSilvino Silva <silvino@bk.ru>2018-04-06 17:43:58 +0100
commit6ee060f04bdd91b66b8dfaa21f29758ae450348f (patch)
tree0ce231727fdbe28bc1ed64546be93f1ee988d7b6 /tools/postgresql.html
parent746c2f76a305d4251f58f3327f8147f60a1be38f (diff)
parent152177eeca633a26a1228cfded025b5a7d861c66 (diff)
downloaddoc-6ee060f04bdd91b66b8dfaa21f29758ae450348f.tar.gz
Merge branch 'r-0.3.3' into develop
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>