diff options
| author | Silvino Silva <silvino@bk.ru> | 2018-03-06 15:57:00 +0000 |
|---|---|---|
| committer | Silvino Silva <silvino@bk.ru> | 2018-03-06 15:57:00 +0000 |
| commit | 73eddbd1550e8573d9d7b31860b75f007de73da8 (patch) | |
| tree | 766ae2a9708efa2bd95b49a5b05b2d549aae4964 | |
| parent | eaf84c661a79e6a56b87ade80cc8467d45c3d8fb (diff) | |
| download | doc-73eddbd1550e8573d9d7b31860b75f007de73da8.tar.gz | |
tools fix postgresql backup
| -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> |