Hi Thomas,
I am aware of of tht above 9.0 thr is default
auto-vacuuming.but I just want to tune according to my
needs..
On Mon, Jul 29, 2013 at 10:01 PM, Thomas Kellerer wrote:
> Manish Kediyal wrote on 29.07.2013 09:17:
>
> I have various DB in my DB cluster, i want to vacuum
Manish Kediyal wrote on 29.07.2013 09:17:
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
Is there a specific reason you don't want to use auto-
Thanks Raghu,
On Mon, Jul 29, 2013 at 1:34 PM, raghu ram wrote:
>
> On Mon, Jul 29, 2013 at 1:07 PM, Manish Kediyal
> wrote:
>
>> Thanks Raghu,
>>
>> Is there a shell script for it, i wanna scheduled that through cron.
>>
>>
> You can create below Script for scheduling purpose:
>
> #!/bin/bash
On Mon, Jul 29, 2013 at 1:07 PM, Manish Kediyal wrote:
> Thanks Raghu,
>
> Is there a shell script for it, i wanna scheduled that through cron.
>
>
You can create below Script for scheduling purpose:
#!/bin/bash
PGHOME=/opt/PostgreSQL/9.2/bin
LOG=/Backup/cron-script-logs
LOGFILE=vacuum_analyze_`d
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 wrote:
> On Mon, Jul 29, 2013 at 12:47 PM, Manish Kediyal > wrote:
>
>> Hi,
>>
>> I have various DB in my DB cluster, i want to vacuum all DB's using
On Mon, Jul 29, 2013 at 12:47 PM, Manish Kediyal
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 vacu
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
Thanks and Regards
Manish Kediyal
