Re: Shell Script for Vacuum
| От | Manish Kediyal |
|---|---|
| Тема | Re: Shell Script for Vacuum |
| Дата | |
| Msg-id | CAP7rq4=NgSu7cnp3nTzXg2c4=_2fddfrt9buhTT+dREYPnDXYA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Shell Script for Vacuum (raghu ram <raghuchennuru@gmail.com>) |
| Ответы |
Re: Shell Script for Vacuum
|
| Список | pgsql-admin |
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 <raghuchennuru@gmail.com> wrote:
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'sYou 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.logThanks & RegardsRaghu Ram
В списке pgsql-admin по дате отправления: