Re: Fwd: Export vaccumdb messages

Hi,

Just for sharing. This is what I'm doing now.

*Crontab*
*0 0 * * * su - postgres -c /var/lib/pgsql/postgres_vacuum.sh*

*Script*
*# cat /var/lib/pgsql/postgres_vacuum.sh*
*#!/bin/bash*

*echo `date` >> /var/lib/pgsql/postgres_vacuum.log*

*ps -aef | grep 'wal sender' | grep -v 'grep wal sender' > /dev/null*

*if [ $? -eq 0 ]; then*
* /usr/pgsql-9.2/bin/vacuumdb -avz >>
/var/lib/pgsql/postgres_vacuum.log 2>>&1*
*else*
* echo "This is a postgres slave. Don't vacuum it!" >>
/var/lib/pgsql/postgres_vacuum.log*
*fi*

Hope this helps.

On 2 September 2015 at 02:54, Marco Nietz <pg(at)mnietz(dot)de> wrote:

> Hi,
>
> try it like this:
>
> vacuumdb -v > /tmp/your.log 2>&1
>
>
> Best,
>
> Marco
>
>
>
> Am 01.09.2015 um 19:21 schrieb Edgar Delgado:
>
>>
>>
>> Hi.
>>
>> How can I export the INFOS that generates from running vaccumdb? Tried
>> ">>" but I don't receive this kind of information:
>>
>>
>> INFO: analyzing "pg_catalog.pg_foreign_data_wrapper"
>> INFO: "pg_foreign_data_wrapper": scanned 0 of 0 pages, containing 0
>> live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
>> INFO: vacuuming "pg_catalog.pg_shseclabel"
>> INFO: "pg_shseclabel": found 0 removable, 0 nonremovable row versions
>> in 0 pages
>> DETAIL: 0 dead row versions cannot be removed yet.
>> CPU 0.00s/0.00u sec elapsed 0.00 sec.
>>
>> I need to generate a log of this and send over e-mail.
>>
>>
>> Thanks,
>>
>>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

--
Regards,
Ang Wei Shan