Re: Shell Script for Vacuum

From: raghu ram <raghuchennuru(at)gmail(dot)com>
To: Manish Kediyal <kediyal(dot)manish(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Shell Script for Vacuum
Date: 2013-07-29 07:26:31
Message-ID: CALnrrJTCJsH0um5O_8WGM6ocjK7jzWDqxrwj3bjxcAQwrmyh6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Manish Kediyal 2013-07-29 07:37:15 Re: Shell Script for Vacuum
Previous Message Manish Kediyal 2013-07-29 07:17:31 Shell Script for Vacuum