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@mnietz.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.