Difference between revisions of "HowTo: Reset Billing PostgreSQL"

Latest revision as of 07:45, 7 August 2015

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...
/etc/init.d/dcache httpd stop
/etc/init.d/postgresql stop
mv /var/lib/pgsql/data /var/lib/pgsql/data.toremove
/etc/init.d/postgresql initdb
Create srmdcache user / role:
su - postgres

createuser srmdcache # Answer yes

createdb -U srmdcache billing

exit
/etc/init.d/dcache httpd start

If everything looks as you like you can now remove the old db:

rm -rf /var/lib/pgsql/data.toremove

@@ Line 7: / Line 7: @@
 :# <tt>mv /var/lib/pgsql/data /var/lib/pgsql/data.toremove</tt>
 :# <tt>/etc/init.d/postgresql initdb</tt>
-:# Create srmdcache user/role:
+:# Create '''srmdcache''' user / role:
 :#: <tt>su - postgres</tt>
 :#: <tt>createuser srmdcache # Answer yes</tt>
@@ Line 14: / Line 14: @@
 :# <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
-Now you've a fresh new DB and all old data in the backup.
+:* The replica is running in dcns05.pic.es
+::* More information under http://wiki.pic.es/index.php/HowTo:_PNFS_backup_in_PITR
-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