[opensuse-factory] Kmail / Akonadi and PostgreSQL
Hi, FYI, after upgrading to snapshot 20171129 the above combo stopped to work. The messages on an akonadictl restart told me it exited due to a database inititiaded by postgres 9.6, where TW moved to 10. I used 'update-alternatives -- config postgresql' to move back to the 9.6 version, and akonadi is back in business. I know this is not the stock config, but pg IME outperforms mysql ( at least in akonadi's case ). -- Gertjan Lettink, a.k.a. Knurpht openSUSE Board Member openSUSE Forums Team -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
Am Freitag, 1. Dezember 2017, 18:16:51 CET schrieb Knurpht - Gertjan Lettink:
Hi,
FYI, after upgrading to snapshot 20171129 the above combo stopped to work. The messages on an akonadictl restart told me it exited due to a database inititiaded by postgres 9.6, where TW moved to 10. I used 'update-alternatives -- config postgresql' to move back to the 9.6 version, and akonadi is back in business. I know this is not the stock config, but pg IME outperforms mysql ( at least in akonadi's case ).
https://bugreports.qt.io/browse/QTBUG-64161 -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
On Friday, 1 December 2017 17:16:51 GMT Knurpht - Gertjan Lettink wrote:
Hi,
FYI, after upgrading to snapshot 20171129 the above combo stopped to work. The messages on an akonadictl restart told me it exited due to a database inititiaded by postgres 9.6, where TW moved to 10. I used 'update-alternatives -- config postgresql' to move back to the 9.6 version, and akonadi is back in business. I know this is not the stock config, but pg IME outperforms mysql ( at least in akonadi's case ).
I have just finished doing the same thing after a few hours of wondering what went wrong, should the install have changed the config or left it as it was? I agree its definitely faster than mysql and most obviously with fsck/vacuum. -- opensuse:tumbleweed:20171129 Qt: 5.9.2 KDE Frameworks: 5.40.0 - KDE Plasma: 5.11.3 - kwin 5.11.3 kmail2 5.6.3 - akonadiserver 5.6.3 - Kernel: 4.14.2-1-default - xf86-video-nouveau: 1.0.15 -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
Op vrijdag 1 december 2017 19:07:15 CET schreef Ianseeks:
On Friday, 1 December 2017 17:16:51 GMT Knurpht - Gertjan Lettink wrote:
Hi,
FYI, after upgrading to snapshot 20171129 the above combo stopped to work. The messages on an akonadictl restart told me it exited due to a database inititiaded by postgres 9.6, where TW moved to 10. I used 'update-alternatives -- config postgresql' to move back to the 9.6 version, and akonadi is back in business. I know this is not the stock config, but pg IME outperforms mysql ( at least in akonadi's case ).
I have just finished doing the same thing after a few hours of wondering what went wrong, should the install have changed the config or left it as it was? I agree its definitely faster than mysql and most obviously with fsck/vacuum.
Yup, at least twice as fast on fsck/vacuum. Also in searches. But, like also on this list, there seems to be a bug that's causing it, so we may have to revert the changes on a next QT update. -- Gertjan Lettink, a.k.a. Knurpht openSUSE Board Member openSUSE Forums Team -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
On Friday, 1 December 2017 18:39:49 GMT Knurpht - Gertjan Lettink wrote:
Op vrijdag 1 december 2017 19:07:15 CET schreef Ianseeks:
On Friday, 1 December 2017 17:16:51 GMT Knurpht - Gertjan Lettink wrote:
Hi,
Yup, at least twice as fast on fsck/vacuum. Also in searches. But, like also on this list, there seems to be a bug that's causing it, so we may have to revert the changes on a next QT update. And also when you apply filters manually, it moves them really fast. I'll try the new postgres when the QT update happens on a clean user.
-- opensuse:tumbleweed:20171129 Qt: 5.9.2 KDE Frameworks: 5.40.0 - KDE Plasma: 5.11.3 - kwin 5.11.3 kmail2 5.6.3 - akonadiserver 5.6.3 - Kernel: 4.14.2-1-default - xf86-video-nouveau: 1.0.15 -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
participants (3)
-
Gerd -
Ianseeks -
Knurpht - Gertjan Lettink