Changes between Version 8 and Version 9 of InstallationGuidelines/PostgreSQL

Timestamp:

09/18/10 12:49:50 (14 years ago)

Author:

Fran Boon

Comment:

--

InstallationGuidelines/PostgreSQL

@@ -46 +46 @@
 }}}
 
+== Backups ==
+{{{
+man pg_dump
+}}}
+
 == Maintenance ==
-If you need to build a fresh database
+If you need to build a fresh database:
 {{{
 rm -f /home/web2py/applications/eden/databases/*
 su postgres
+pkill -f 'postgres: sahana sahana'
 dropdb sahana
 createdb -O sahana -E UTF8 sahana
+}}}
+
+To restore data from backup:
+{{{
+man pg_restore
 }}}