Blog
Paraccel - Script to run the various regular housekeeping jobs for a given database.
|
|
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!
The words you entered did not match the given text. Please try again.
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
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
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
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
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
viagra 100mg canadian pharmacy cialis 20mg generic cialis from canada
url=http://www.canadotcphar.com/ says...canadadrugstoresonline.com
generic cialis canada pharmacy online
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
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
cheap cialis from canada my canadian pharmacy buying viagra from canada
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
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
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.
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
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
Oops!
Oops, you forgot something.