Blog

Paraccel - Script to run the various regular housekeeping jobs for a given database.

Posted by Irtaza Hassan on November 17, 2014 at 6:40 AM

The credit for this script goes to Graham Mossman

###

### housekeeping.bash

###

### Usage:

### ./housekeeping.bash <database>

###

### Description:

### Script to run the various regular housekeeping jobs for a given database.

###

source /home/paraccel/.bashrc # this is how $housekeeping_log_dir is set

today=`date +%Y-%m-%d`

database=$1

logfile=`echo ${housekeeping_log_dir}/housekeeping_${database}_${today}.log`

echo "Starting housekeeping for $database at `date`" > $logfile 2>&1

echo "starting analyze at `date`" >>$logfile 2>&1

echo "analyze"|psql $database >> $logfile 2>&1

echo "starting vacuum at `date`" >> $logfile 2>&1

echo "vacuum"|psql $database >> $logfile 2>&1

echo "starting vacuumcat at `date`" >> $logfile 2>&1

echo "vacuumcat"|psql $database >> $logfile 2>&1

echo "starting indexcat at `date`" >> $logfile 2>&1

echo "indexcat"|psql $database >> $logfile 2>&1

echo "Ending housekeeping for $database at `date`" >> $logfile 2>&1

 

 

 

Categories: Actian Matrix (Paraccel)

Post a Comment

Oops!

Oops, you forgot something.

Oops!

The words you entered did not match the given text. Please try again.

Already a member? Sign In

614 Comments

Reply SirLem
2:04 PM on February 13, 2022 
darkmarket best darknet markets
Reply DavidThabs
2:12 PM on February 18, 2022 
trust.zone vpn
trust zone vpn
avast secureline vpn
Reply pnbnvn
8:14 AM on May 29, 2022 
azithromycin without a doctor's prescription antibiotic azithromycin z pack how to write z pack azithromycin zithromax 500mg for sale
Reply gdp04a
2:43 PM on June 1, 2022 
albuterol sulfate inhalation solution albuterol inhaler 90 mcg
Reply zjosxa
9:26 PM on June 1, 2022 
z pack dosage azithromycin 500 mg z pak azithromycin fish antibiotics for sale
Reply jgbkpi
1:39 PM on June 2, 2022 
stromectol for sale ivermectin for humans for sale
Reply Cilaneta
10:57 PM on June 5, 2022 
lasix dosage for elderly
medication lasix 20 mg
lasix tablet
furosemide 40 mg side effects
furosemide 40
Reply wlc76v
3:22 PM on June 11, 2022 
pfizer discount coupons for viagra details about viagra tablet
Reply hjwmzm
10:59 PM on June 11, 2022 
cost of ventolin generic ventolin inhalers for sale
Reply Uteraky
6:19 AM on June 17, 2022 
generic viagra cheap uk pfizer viagra pills
Reply Boagotip
9:48 PM on June 19, 2022 
buy viagra und cialis http://bluethshop.com can i take two viagra tablets
Reply CRYDAY
4:36 AM on June 21, 2022 
online pharmacy canadian pharmacy viagra with prescription
Reply Brekly
9:13 AM on July 9, 2022 
malaria drug plaquenil how to get hydroxychloroquine prescription
Reply Stephengob
4:33 PM on July 19, 2022 
Many thanks! A lot of tips!

canada pharmacies online pharmacy pharmacie canadian meds
buying drugs canada prescription discount best canadian prescription prices
Reply GerardTot
5:33 PM on July 19, 2022 
Really lots of great information!

canadian pharmacy king canadian online pharmacies best online pharmacy
walmart pharmacy online canada pharmacy no prescription buy medication without an rx
Reply GerardTot
6:05 PM on July 19, 2022 
Very good stuff. Many thanks!

prescription online canadian pharmacy viagra brand canadian pharcharmy online
online pharmacies cialis from canada canadian drugstore reviews
Reply Stephengob
8:13 PM on July 19, 2022 
Thanks, Awesome stuff.

national pharmacies online northwest pharmacy/com canadian drugstore online
canadian drug stores online top rated canadian pharmacies online reputable canadian mail order pharmacies
Reply Stephengob
12:05 AM on July 20, 2022 
Fine tips. Thank you.

canadian pharmacy 365 cialis canadian pharmacy buy viagra pharmacy 100mg
navarro pharmacy miami ed meds online without doctor prescription medicine online order
Reply BrettZow
12:11 AM on July 20, 2022 
With thanks, A lot of posts!

canada prescription plus pharmacy drugs from canada meds online
aarp recommended canadian pharmacies prescription prices comparison pharmacy discount