1 To dump mir database <dbname>:
2 pg_dumplo -a -d <dbname> -s /dumpdir/dir
3 pg_dump -c -D -f /dumpdir/<dbname>.sql <dbname>
4 this generates a dir with all blobs and a sql-file with all data.
6 To restore the database:
7 psql <dbname> < <dbname>.sql
8 pgdump_lo -i -d <dbname> -s /dumpdir/dir
10 Every once in a while (or make a script) postgresql database should
11 be "cleaned". See postgresql docs for commands VACUUM and VACUUM ANALYZE
13 Every once in a while (or make a script) postgresql database should
14 be "cleaned". See postgresql docs for commands VACUUM and VACUUM ANALYZE