On Mon, Jul 29, 2013 at 1:07 PM, Manish Kediyal <kediyal(dot)manish(at)gmail(dot)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