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 <raghuchenn...@gmail.com> wrote: > On Mon, Jul 29, 2013 at 12:47 PM, Manish Kediyal <kediyal.man...@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 >
