[Spacewalk-list] Switching the jabberd database to sqlite/pgsql

[Ree, Jan-Albert van]

While SQLite is already better than the default BerkeleyDB, I'd suggest skipping SQLite and moving straight to PostgreSQL for the jabberd backend. For our installation (with around 75 clients) this has solved all OSAD instabilities, it's been running for several weeks now without any lost connections. Even with SQLite we never managed that.
--
Jan-Albert van Ree


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/CFD-simulations-and-experiments-of-a-maneuvering-generic-submarine-and-prognosis-for-simulation-of-near-surface-operation-1.htm

_______________________________________
From: spacewalk-list-bounces at redhat.com <spacewalk-list-bounces at redhat.com> on behalf of Robert Paschedag <robert.paschedag at web.de>
Sent: Saturday, March 04, 2017 07:54
To: spacewalk-list at redhat.com; Avi Miller
Subject: Re: [Spacewalk-list] Switching the jabberd database to sqlite/pgsql

Am 3. März 2017 22:11:27 MEZ schrieb Avi Miller <avi.miller at oracle.com>:
>Hi everyone,
>
>I was searching for a simple tutorial on how to switch the jabberd
>database away from the Spacewalk default of BerkeleyDB to something
>more robust. While I did find some scattered documentation, there was
>nothing specific for Spacewalk, so I wrote up two:
>
>Switching to SQLite:
>
>https://omg.dje.li/2017/02/configuring-spacewalks-jabberd-to-use-an-sqlite-backend/
>
>Switching to PostgreSQL:
>
>https://omg.dje.li/2017/03/configuring-spacewalks-jabberd-to-use-a-postgresql-backend/
>
>Hopefully someone finds this useful. If anything is unclear or if you
>have any comments/improvements/corrections, please let me know!
>
>Thanks,
>Avi
>
>--
>Oracle <http://www.oracle.com>
>Avi Miller | Product Management Director | +61 (3) 8616 3496
>Oracle Linux and Virtualization
>417 St Kilda Road, Melbourne, Victoria 3004 Australia
>
>
>_______________________________________________
>Spacewalk-list mailing list
>Spacewalk-list at redhat.com
>https://www.redhat.com/mailman/listinfo/spacewalk-list

Hi Avi,

Thank you for sharing this information. Although I did not yet had many problems with the jabber db, I heard it should be far better with SQLite.

Regards
Robert

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