[Spacewalk-list] Maintaining JabberD/PostgreSQL

[Ree, Jan-Albert van]

I run the following line from the psql user cron every night to clean up the database

psql -d jabberd2 -c "VACUUM FULL ANALYZE VERBOSE" >> /var/log/rhn/spacewalk-database-maintenance.txt 2>&1

This seems to work for me, even the check_mk postgresql check doesn't complain about table bloat any more.
--
Jan-Albert


Jan-Albert van Ree  | Linux System Administrator | MARIN Support Group
MARIN | T +31 317 49 35 48 | mailto:J.A.v.Ree at marin.nl | http://www.marin.nl

MARIN news: http://www.marin.nl/web/News/News-items/Maritime-Safety-seminar-September-12-Singapore.htm

________________________________________
From: spacewalk-list-bounces at redhat.com <spacewalk-list-bounces at redhat.com> on behalf of Eric <ericb at enrsystems.com>
Sent: Thursday, June 22, 2017 17:59
To: spacewalk-list at redhat.com
Subject: [Spacewalk-list] Maintaining JabberD/PostgreSQL

So now that I've got Jabberd switched over to Postgres following AVI's blog,
does anyone have any specific tips on how to prune the old entries?

I'd like to be able to clean it up fairly regularly, as it does grow pretty
fast.

Thanks,

Eric

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list