<table><tr><td style="">nl6720 created this revision.<br />nl6720 added a reviewer: KDE PIM.<br />nl6720 added a project: KDE PIM.<br />Herald added a subscriber: kde-pim.<br />nl6720 requested review of this revision.
</td><a style="text-decoration: none; padding: 4px 8px; margin: 0 8px 8px; float: right; color: #464C5C; font-weight: bold; border-radius: 3px; background-color: #F7F7F9; background-image: linear-gradient(to bottom,#fff,#f1f0f1); display: inline-block; border: 1px solid rgba(71,87,120,.2);" href="https://phabricator.kde.org/D22154">View Revision</a></tr></table><br /><div><strong>REVISION SUMMARY</strong><div><p>Arch Linux packages places old PostgreSQL in <tt style="background: #ebebeb; font-size: 13px;">/opt/pgsql-PG_VERSION/</tt>. See <a href="https://www.archlinux.org/packages/extra/x86_64/postgresql-old-upgrade/files/" class="remarkup-link" target="_blank" rel="noreferrer">https://www.archlinux.org/packages/extra/x86_64/postgresql-old-upgrade/files/</a> .</p></div></div><br /><div><strong>TEST PLAN</strong><div><h2 class="remarkup-header">The lazy method</h2>

<p>Install <a href="https://www.archlinux.org/packages/extra/x86_64/postgresql/" class="remarkup-link" target="_blank" rel="noreferrer">postgresql</a> and <a href="https://www.archlinux.org/packages/extra/x86_64/postgresql-old-upgrade/" class="remarkup-link" target="_blank" rel="noreferrer">postgresql-old-upgrade</a>.<br />
Create <tt style="background: #ebebeb; font-size: 13px;">~/.config/akonadi/akonadiserverrc</tt>:</p>

<div class="remarkup-code-block" style="margin: 12px 0;" data-code-lang="text" data-sigil="remarkup-code-block"><pre class="remarkup-code" style="font: 11px/15px "Menlo", "Consolas", "Monaco", monospace; padding: 12px; margin: 0; background: rgba(71, 87, 120, 0.08);">[%General]
Driver=QPSQL

[QPSQL]
ServerPath=/opt/pgsql-10/bin/pg_ctl
InitDbPath=/opt/pgsql-10/bin/initdb</pre></div>

<p>Start Akonadi: <tt style="background: #ebebeb; font-size: 13px;">akonadictl start</tt>.<br />
Stop Akonadi: <tt style="background: #ebebeb; font-size: 13px;">akonadictl stop</tt>.</p>

<p>Update <tt style="background: #ebebeb; font-size: 13px;">~/.config/akonadi/akonadiserverrc</tt>:</p>

<div class="remarkup-code-block" style="margin: 12px 0;" data-code-lang="text" data-sigil="remarkup-code-block"><pre class="remarkup-code" style="font: 11px/15px "Menlo", "Consolas", "Monaco", monospace; padding: 12px; margin: 0; background: rgba(71, 87, 120, 0.08);">[%General]
Driver=QPSQL

[QPSQL]
...
ServerPath=/us/bin/pg_ctl
InitDbPath=/usr/bin/initdb
...</pre></div>

<p>Start Akonadi: <tt style="background: #ebebeb; font-size: 13px;">akonadictl start</tt>.<br />
The database cluster should get successfully updated.</p></div></div><br /><div><strong>REPOSITORY</strong><div><div>R165 Akonadi </div></div></div><br /><div><strong>REVISION DETAIL</strong><div><a href="https://phabricator.kde.org/D22154">https://phabricator.kde.org/D22154</a></div></div><br /><div><strong>AFFECTED FILES</strong><div><div>src/server/storage/dbconfigpostgresql.cpp</div></div></div><br /><div><strong>To: </strong>nl6720, KDE PIM<br /><strong>Cc: </strong>kde-pim, KDE PIM, dvasin, rodsevich, winterz, vkrause, mlaurent, knauss, dvratil<br /></div>