HowTo: Reset Billing PostgreSQL

• No scheduled downtime is required because service is unaffected (accounting is affected).
• Steps

1. Connect to dcip.pic.es (where the billing database resides)
2. Make a backup of the DB (or pick one from /DBbackups and save for future references). Bacula should be keeping track of this directory...
3. /etc/init.d/dcache httpd stop
4. /etc/init.d/postgresql stop
5. mv /var/lib/pgsql/data /var/lib/pgsql/data.toremove
6. /etc/init.d/postgresql initdb
7. Create srmdcache user/role:

su postgres
createuser srmdcache   #Answer yes
createdb -U srmdcache billing
exit

1. /etc/init.d/dcache httpd start

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 resyncronize the Streaming replica of the database. On 9/6/2011 the replica is running in dcns05.pic.es More information under http://wiki.pic.es/index.php/HowTo:_PNFS_backup_in_PITR