Re: Shell Script for Vacuum

[Manish Kediyal <kediyal.manish@xxxxxxxxx>]

Thanks Raghu,

Is there a shell script for it, i wanna scheduled that through cron.

Thanks

Manish

On Mon, Jul 29, 2013 at 12:56 PM, raghu ram <raghuchennuru@xxxxxxxxx> wrote:

On Mon, Jul 29, 2013 at 12:47 PM, Manish Kediyal <kediyal.manish@xxxxxxxxx> wrote:

Hi, 

I have various DB in my DB cluster, i want to vacuum all DB's using a shell script...... scheduling via cron.

It would be a great help if anyone could provide me a Shell Script to vacuum all DB's

You can perform vacuum for all databases available in PostgreSQL Instance using "vacuumdb" utility and Command as follows:

/opt/PostgreSQL/9.2/bin/vacuumdb -a -z -v >> /tmp/vacuumanalyze.log 2>> /tmp/vacuumanalyze.log 

Thanks & Regards

Raghu Ram