Re: Shell Script for Vacuum - Mailing list pgsql-admin

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