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
