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