Re: Shell Script for Vacuum

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(at)gmail(dot)com> wrote:

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