HowTo: Reset Billing PostgreSQL - Revision history

Mcaubet at 07:45, 7 August 2015

2015-08-07T07:45:15Z

Mcaubet at 07:45, 7 August 2015

2015-08-07T07:45:08Z

Mcaubet at 07:43, 7 August 2015

2015-08-07T07:43:37Z

Mcaubet: Created page with "* 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 ba..."

2015-08-07T07:37:12Z

Created page with "* 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 ba..."

New page

* 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

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

@@ Line 13: / Line 13: @@
 :#: <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.

@@ 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 15: / Line 15: @@
-Now you've a fresh new DB and all old data in the backup.
+* It is necessary to re-synchronize the '''''streaming replica''''' of the database. O
+:* The replica is running in dcns05.pic.es
-If everything looks as you like you can now remove the old db:
+::* More information under http://wiki.pic.es/index.php/HowTo:_PNFS_backup_in_PITR

@@ Line 3: / Line 3: @@
 :# 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
+:# <tt>/etc/init.d/dcache httpd stop</tt>
-:# /etc/init.d/postgresql stop
+:# <tt>/etc/init.d/postgresql stop</tt>
-:# mv /var/lib/pgsql/data /var/lib/pgsql/data.toremove
+:# <tt>mv /var/lib/pgsql/data /var/lib/pgsql/data.toremove</tt>
-:# /etc/init.d/postgresql initdb
+:# <tt>/etc/init.d/postgresql initdb</tt>
 :# Create srmdcache user/role:
- su postgres
+:#: <tt>su - postgres</tt>
- createuser srmdcache   #Answer yes
+:#: <tt>createuser srmdcache # Answer yes</tt>
- createdb -U srmdcache billing
+:#: <tt>createdb -U srmdcache billing</tt>
- exit
+:#: <tt>exit</tt>
-:# /etc/init.d/dcache httpd start
+:# <tt>/etc/init.d/dcache httpd start</tt>