Re: Shell Script for Vacuum

On Mon, Jul 29, 2013 at 12:47 PM, Manish Kediyal <kediyal.manish@gmail.com> 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