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 sims 4 counter slots aom
7:36 PM on September 26, 2022 
300 free slots no download free pop slots chips slotss https://onlinecasinohero.com/scorchy-slots-guide
Reply sims 4 counter slots aom
7:38 PM on September 26, 2022 
300 free slots no download free pop slots chips slotss https://onlinecasinohero.com/scorchy-slots-guide
Reply Healty
3:04 PM on September 27, 2022 
traelo priligy priligy online purchase priligy drug can i buy priligy over the counter in canada
Reply fjlfw5rwi6v
6:47 PM on September 29, 2022 
clt4gqqhfzg cialis without prescription viagra dose viagra sildenafil canadian pharmacy.reviews buy cialis online canada pharmacy
how much is viagra how long does viagra last drugs-med.com best viagra canadian meds
order viagra without prescription canada drugstore canada pharmacy for cialis medications in canada viagra price
Reply xqwbl0xvfv1
3:01 PM on October 5, 2022 
ze03on8q7u6 viagra plus canadian-drugstore drug store online viagra overdose natural substitute for viagra
cialis at canadian pharmacy free sample viagra price of cialis in canada online prescription viagra walmart viagra price
viagra generic viagra overdose daily cialis viagra best price online canadian pharcharmy
Reply Anthonyhob
9:11 AM on October 16, 2022 
????? 24 (?????24) - ?????? ?????? ????????? #1 ? ?????? ????? 24
Reply OGuachujo
11:52 PM on October 18, 2022 
Orgy game in the garage with a group of sexy sluts https://wankmovie.com/ Hardcore fucking at home with large ass ebony girlfriend Chanell Heart
Reply Qickjaehodolo
10:41 AM on October 19, 2022 
Comprare Spedra generico Avanafil avanafil generico prezzo
Reply onlinepharmacy.com
10:09 AM on October 25, 2022 
how long does viagra last onlinepharmacy.com viagra overnight shipping
viagra without a doctor prescription canada approved canadian online pharmacies viagra online uk
Reply ceteanon
11:56 AM on October 28, 2022 
can you buy dapoxetine over the counter priligy 60mg uk priligy generic canada https://dapoxetinedon.com
Reply jtm3aril58w
10:56 PM on November 4, 2022 
enwotuekwbt canadian pharmacy online for viagra cheap viagra in canada buy drugs online ed meds canadian cheap viagra
getting a prescription online cialis usa pharmacy viagra free trial cialis without a prescription drug world canada
discount cialis rite aid pharmacies viagra overnight online canadian pharmacies cheap viagra online canada pharmacy
Reply onlinepharmaciescanada.com
9:51 PM on November 6, 2022 
canadian viagra online pharmacy reviews
url=http://www.canadotcphar.com/ says...
generic cialis canada pharmacy online
canadadrugstoresonline.com
viagra 100mg canadian pharmacy cialis 20mg generic cialis from canada
Reply jd4ev6mx4p3
12:06 PM on November 9, 2022 
thxjbjukyv6 canadian online pharmacy for cialis rx online cialis canadian pharmacies order cialis in canada viagra side effects
ed meds pharmacy viagra viagra 100 free samples canada viagra 100
cialis- canadian pharmacy viagra natural canadian meds ed drugs - canada canadian prescriptions
Reply canadian pharmacy - cialis
3:42 PM on November 13, 2022 
order medication online canadian pharmacy without prescription overseas pharmacy
cheap cialis from canada my canadian pharmacy buying viagra from canada
Reply glotalA
9:32 PM on November 18, 2022 
src44k canadian discount pharmacy belleview fl jxau65
Reply kvyko4voa5e
5:51 AM on November 19, 2022 
dv2zp6bi925 viagra prescriptions viagra prescription drugs from canada prices viagra dosing viagra coupons
canada pharmacies online prescriptions cialis canadian pharmacy's cheap generic viagra online canadian pharmacies without prescriptions cheap celias
cheap viagra uk cialis canada pharmacy how does cialis work viagra coupon cialis- canadian pharmacy
Reply www.canadian pharmacy
3:29 PM on November 20, 2022 
online prescription canadian overnight pharmacy viagra india
generic viagra reviews cialis at canadian pharmacies canadian pharmacy - cialis
Reply AuBouby
3:13 PM on November 29, 2022 
Can impotency be cured naturally female viagra medicine price in india?
There's no obdurate and accelerated in the main when it comes to how many erections a person should get. People with penises be enduring an average of 11 erections per hour and three to five more each end of day, but one is different.
Reply oig5ts9k863
4:54 PM on November 30, 2022 
elbohppkrft when will viagra go generic online purchase viagra canadian meds viagra how to use viagra canadian pharmacies shipping to usa
viagra online northwestern pharmacy canada canadian pharcharmy ed drugs - canada canadian drug
generic viagra canada viamedic.com is there a generic cialis where to buy viagra online canadian levitra
Reply BaaLem
9:25 PM on December 1, 2022 
dark web sites links onion market