Akonadi/Postgres update: Difference between revisions
(Add the postgresql upgrade howto) |
(Add translate tag and more information section) |
||
| Line 1: | Line 1: | ||
<languages /> | |||
<translate> | |||
This guide describes the steps to follow in order to upgrade your Akonadi database when using the PostgreSQL backend. | This guide describes the steps to follow in order to upgrade your Akonadi database when using the PostgreSQL backend. | ||
| Line 20: | Line 22: | ||
{{Input|1=/usr/lib/postgresql11/bin/initdb --pgdata=$HOME/.local/share/akonadi/db_data --locale=en_US.UTF-8}} | {{Input|1=/usr/lib/postgresql11/bin/initdb --pgdata=$HOME/.local/share/akonadi/db_data --locale=en_US.UTF-8}} | ||
Do '''NOT''' change the --locale value. | {{Warning|Do '''NOT''' change the <code>--locale</code> value.}} | ||
Check if upgrading is safe | 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}} | {{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}} | ||
| Line 37: | Line 38: | ||
After checking that your applications work as usual, you may delete the two backup copies you created earlier. | After checking that your applications work as usual, you may delete the two backup copies you created earlier. | ||
== More Information == | |||
* [https://wiki.archlinux.org/index.php/PostgreSQL#Upgrading_PostgreSQL Upgrading PostgreSQL] (Arch linux wiki) | |||
* [https://www.postgresql.org/docs/current/pgupgrade.html Upgradinf PostgreSQL] (Official PostgreSQL documentation) | |||
</translate> | |||
Revision as of 22:09, 14 March 2019
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.
The initdb and pg_upgrade tools are required. Make sure these applications are available before following this guide.
Stop the Akonadi services
akonadictl stop
(wait until all the akonadi processes are gone)
Create an extra backup
cp -R $HOME/.local/share/akonadi/db_data $HOME/.local/share/akonadi/db_data_10
Rename the Akonadi database directory
mv $HOME/.local/share/akonadi/db_data $HOME/.local/share/akonadi/db_data_old
Create the new database, using the postgreSQL 11 executable
/usr/lib/postgresql11/bin/initdb --pgdata=$HOME/.local/share/akonadi/db_data --locale=en_US.UTF-8
--locale value.Check if upgrading is safe
/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
For more details about this command, you may read the pg_upgrade documentation.
If pg_upgrade doesn't detect any problem, you can start the database upgrade
/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
Last steps, starting akonadi
akonadictl start
and running the consistency check
akonadictl fsck
After checking that your applications work as usual, you may delete the two backup copies you created earlier.
More Information
- Upgrading PostgreSQL (Arch linux wiki)
- Upgradinf PostgreSQL (Official PostgreSQL documentation)