diff options
| -rw-r--r-- | tools/postgresql.html | 11 |
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 < database_dump + $ gzip -c cluster_dump.gz | psql -U postgres </pre> <a href="index.html">Tools Index</a> |