Postgres Pro
Downloads
Home   >   mailing lists

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

From raghu ram
Subject Re: Shell Script for Vacuum
Date
Msg-id CALnrrJTCJsH0um5O_8WGM6ocjK7jzWDqxrwj3bjxcAQwrmyh6A@mail.gmail.com
Whole thread Raw
In response to Shell Script for Vacuum  (Manish Kediyal <kediyal.manish@gmail.com>)
Responses Re: Shell Script for Vacuum  (Manish Kediyal <kediyal.manish@gmail.com>)
Re: Shell Script for Vacuum  (rajivmehta0201 <rajivmehta0201@gmail.com>)
List pgsql-admin
Tree view
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 

pgsql-admin by date:

Previous
From: Manish Kediyal
Date:
Subject: Shell Script for Vacuum
Next
From: Manish Kediyal
Date:
Subject: Re: Shell Script for Vacuum