4 To dump the database use pg_dump
6 pg_dump -Ft -b -u -f dump.tar [name_of_database]
8 To restore do the following
10 pg_restore -d [name_of_database] -u [dbuser] -Ft dump.tar
13 VACUUM and VACUUM ANALYZE
15 Every once in a while (or make a script) postgresql database should
16 be "cleaned". See postgresql docs for commands VACUUM and VACUUM ANALYZE
20 We also have misc. perl scripts to merge Large Objects from other DB's.
21 these can be used as a basis to write your own custom scripts.
24 USER MANAGMENT IN POSTGRESQL
26 If you want to change the db user of a mir db, there's a script for
27 that in mir/dbscripts/extra.