Thanks Raghu,
On Mon, Jul 29, 2013 at 1:34 PM, raghu ram <[email protected]> wrote: > > On Mon, Jul 29, 2013 at 1:07 PM, Manish Kediyal > <[email protected]>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 >
