-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