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