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