View source for HowTo: Reset Billing PostgreSQL

* No scheduled downtime is required because service is unaffected (accounting is affected).
* Steps
:# Connect to dcip.pic.es (where the billing database resides)
:# Make a backup of the DB (or pick one from /DBbackups and save for future references). Bacula should be keeping track of this directory...
:# <tt>/etc/init.d/dcache httpd stop</tt>
:# <tt>/etc/init.d/postgresql stop</tt>
:# <tt>mv /var/lib/pgsql/data /var/lib/pgsql/data.toremove</tt>
:# <tt>/etc/init.d/postgresql initdb</tt>
:# Create '''srmdcache''' user / role:
:#: <tt>su - postgres</tt>
:#: <tt>createuser srmdcache # Answer yes</tt>
:#: <tt>createdb -U srmdcache billing</tt>
:#: <tt>exit</tt>
:# <tt>/etc/init.d/dcache httpd start</tt>

* Now you've a fresh new DB and all old data in the backup.
: If everything looks as you like you can now remove the old db:
 rm -rf /var/lib/pgsql/data.toremove

* It is necessary to re-synchronize the '''''streaming replica''''' of the database. O
:* The replica is running in dcns05.pic.es 
::* More information under http://wiki.pic.es/index.php/HowTo:_PNFS_backup_in_PITR