Translate

Translate to татарча / tatarça

Translation of the wiki page Akonadi/Postgres update from English (en) to татарча (tt)

This tool does not work without JavaScript. JavaScript is disabled, failed to work, or this browser is unsupported.

Translations:Akonadi/Postgres update/Page display title/tt

Akonadi/Postgres update

You need translation rights to translate messages.Get permission

This guide describes the steps to follow in order to upgrade your Akonadi database when using the PostgreSQL backend.‎

In order to use this guide, you need to have both the old and new PostgreSQL versions installed. The applications paths mentioned below are valid for openSUSE users. You may have to adapt these paths for your distribution.‎

Edit

The '''initdb''' and '''pg_upgrade''' tools are required. Make sure these applications are available before following this guide. In openSUSE '''pg_upgrade''' is part of the '''postgresql-contrib''' package.‎

Edit

Stop the Akonadi services {{Input|1=akonadictl stop}}‎

Edit

(wait until all the akonadi processes are gone)‎

Edit

Create an extra backup {{Input|1=cp -R $HOME/.local/share/akonadi/db_data $HOME/.local/share/akonadi/db_data_10}}‎

Edit

Rename the Akonadi database directory {{Input|1=mv $HOME/.local/share/akonadi/db_data $HOME/.local/share/akonadi/db_data_old}}‎

Edit

Create the new database, using the postgreSQL 11 executable {{Input|1=/usr/lib/postgresql11/bin/initdb --pgdata=$HOME/.local/share/akonadi/db_data --locale=en_US.UTF-8}}‎

Edit

{{Warning|Do '''NOT''' change the <code>--locale</code> value.}} Check if upgrading is safe {{Input|1=/usr/lib/postgresql11/bin/pg_upgrade -b /usr/lib/postgresql10/bin -B /usr/lib/postgresql11/bin -d $HOME/.local/share/akonadi/db_data_old -D $HOME/.local/share/akonadi/db_data --check}}‎

Edit

For more details about this command, you may read the [https://www.postgresql.org/docs/current/pgupgrade.html pg_upgrade] documentation.‎

Edit

If pg_upgrade doesn't detect any problem, you can start the database upgrade {{Input|1=/usr/lib/postgresql11/bin/pg_upgrade -b /usr/lib/postgresql10/bin -B /usr/lib/postgresql11/bin -d $HOME/.local/share/akonadi/db_data_old -D $HOME/.local/share/akonadi/db_data}}‎

Edit

Last steps, starting akonadi {{Input|1=akonadictl start}}‎

Edit

and running the consistency check {{Input|1=akonadictl fsck}}‎

Edit

After checking that your applications work as usual, you may delete the two backup copies you created earlier.‎

Edit

== More Information ==‎

Edit

* openSUSE Leap 15.2: Akonadi fails to start after upgrading to PostgreSQL 12 with the same error as in https://bugs.archlinux.org/task/64562. Workaround: Install PostgreSQL 11, set it as default (with '''update-alternatives'''), and upgrade to PostgreSQL 11. * [https://wiki.archlinux.org/index.php/PostgreSQL#Upgrading_PostgreSQL Upgrading PostgreSQL] (Arch linux wiki) * [https://www.postgresql.org/docs/current/pgupgrade.html Upgrading PostgreSQL] (Official PostgreSQL documentation)‎

Edit