Changes between Version 8 and Version 9 of InstallationGuidelines/PostgreSQL


Ignore:
Timestamp:
09/18/10 12:49:50 (11 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • InstallationGuidelines/PostgreSQL

    v8 v9  
    4646}}}
    4747
     48== Backups ==
     49{{{
     50man pg_dump
     51}}}
     52
    4853== Maintenance ==
    49 If you need to build a fresh database
     54If you need to build a fresh database:
    5055{{{
    5156rm -f /home/web2py/applications/eden/databases/*
    5257su postgres
     58pkill -f 'postgres: sahana sahana'
    5359dropdb sahana
    5460createdb -O sahana -E UTF8 sahana
     61}}}
     62
     63To restore data from backup:
     64{{{
     65man pg_restore
    5566}}}
    5667