From 32a9f823dc39ea68d09005071f43e570a1ca81b7 Mon Sep 17 00:00:00 2001
From: rk <rk>
Date: Wed, 19 Mar 2003 19:18:23 +0000
Subject: [PATCH] update doc for dump&restore

---
 doc/MAINTENANCE.postgresql | 23 ++++++++++++++---------
 1 file changed, 14 insertions(+), 9 deletions(-)

diff --git a/doc/MAINTENANCE.postgresql b/doc/MAINTENANCE.postgresql
index df5cae54..0cc7df07 100755
--- a/doc/MAINTENANCE.postgresql
+++ b/doc/MAINTENANCE.postgresql
@@ -1,21 +1,26 @@
-To dump mir database <dbname>:
-	pg_dumplo -a -d <dbname> -s /dumpdir/dir
-	pg_dump -c -D -f /dumpdir/<dbname>.sql <dbname>
-this generates a dir with all blobs and a sql-file with all data.
 
-To restore the database:
-	psql <dbname> < <dbname>.sql
-	pgdump_lo -i -d <dbname> -s /dumpdir/dir
+DUMP & RESTORE
 
-Every once in a while (or make a script) postgresql database should
-be "cleaned". See postgresql docs for commands VACUUM and VACUUM ANALYZE
+To dump the database use pg_dump
+
+  pg_dump -Ft -b -u -f dump.tar [name_of_database]
+
+To restore do the following
+
+  pg_restore -d [name_of_database] -U [dbuser] -Ft dump.tar 
+
+
+VACUUM and VACUUM ANALYZE
 
 Every once in a while (or make a script) postgresql database should
 be "cleaned". See postgresql docs for commands VACUUM and VACUUM ANALYZE
 
+MISC
+
 We also have misc. perl scripts to merge Large Objects from other DB's.
 these can be used as a basis to write your own custom scripts.
 
+
 USER MANAGMENT IN POSTGRESQL
 
 -- set owner of datbase
-- 
2.11.0