On Mon, Jul 29, 2013 at 1:07 PM, Manish Kediyal
<kediyal.manish@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
