Thanks Raghu,
On Mon, Jul 29, 2013 at 1:34 PM, raghu ram <raghuchenn...@gmail.com> wrote: > > On Mon, Jul 29, 2013 at 1:07 PM, Manish Kediyal > <kediyal.man...@gmail.com>wrote: > >> Thanks Raghu, >> >> Is there a shell script for it, i wanna scheduled that through cron. >> >> > You can create below Script for scheduling purpose: > > #!/bin/bash > PGHOME=/opt/PostgreSQL/9.2/bin > LOG=/Backup/cron-script-logs > LOGFILE=vacuum_analyze_`date +"%Y-%m-%d-%T"`.log > > $PGHOME/vacuumdb -a -z -v >> $LOG/$LOGFILE 2>> $LOG/$LOGFILE > > Thanks & Regards > Raghu Ram >
