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`


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, you forgot something.


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

Already a member? Sign In


Reply Jamosdoozy
7:31 AM on May 31, 2021 
Terrific information. Regards.
Reply Jamosdoozy
7:04 AM on June 3, 2021 
Incredible a good deal of superb facts.
essay writer funny
homework help cpm
how to write argumentative essays
help writing paper
how to buy essays online
essay typer
how to write a good descriptive essay
best essay writing services
writing an essay steps
help essay 123
pay for college essays
Reply Jamosdoozy
7:55 PM on June 3, 2021 
Regards, I enjoy this.
write my essay affordable
paper help
write a college essay
argumentative essay
steps to writing a good essay
good thesis statement
writing essay for college
write papers
college essay funny
define thesis
top essay editing service
essays writer
what to write an essay about
Reply Jamosdoozy
9:11 AM on June 4, 2021 
Truly a lot of valuable advice!
essay writing services for cheap
essay writing services
college essays on diversity
phd thesis help
improving essay writing
writer essay
how to write a thesis statement
essay 123 help
how to write a five paragraph essay
my homework
mit college essays
Reply Jamosdoozy
10:47 AM on June 5, 2021 
Nicely put. Thanks.
steps to writing a college essay
dissertation online
autobiography essay for college
help thesis writing
editing essay services
paper writing service
college education essay
thesis editing
essay about reading and writing
writing essays for scholarships
paper writing
admissions essay help
Reply Jamosdoozy
12:06 AM on June 7, 2021 
Really all kinds of terrific info.
pharmacy online store
Reply Jamosdoozy
2:48 AM on June 8, 2021 
Kudos, Loads of posts.
help write essay online
analysis essay writing
essays service
best essay for you
Reply Jamosdoozy
3:41 AM on June 9, 2021 
You actually revealed this really well!
persuasive essay on why college athletes should be paid
writing a hook for an essay
essay prompts college
how to write a citation in an essay
Reply Jamosdoozy
5:29 AM on June 10, 2021 
Reply Jamosdoozy
6:27 AM on June 11, 2021 
You actually stated it well.
admission essay writing
how to write a reflective essay
write a personal essay
personal statement college essay
Reply Jamosdoozy
8:46 AM on June 12, 2021 
Thank you. Fantastic stuff!
custom essay toronto
quotes about writing essays
essays on college life
how to write the conclusion of an essay
Reply Jamosdoozy
10:13 AM on June 13, 2021 
Great postings. Appreciate it.
how to write a really good essay
reflective writing essay
websites for essays in english
college transfer essay
Reply Jamosdoozy
7:09 AM on June 15, 2021 
Appreciate it. Lots of facts!