Create Task
Maniphest T836

[Akonadi/PSQL] Support DB update with pg_upgrade
Closed, ResolvedPublic
Actions

Description

Major PSQL updates usually require that user runs pg_upgrade. It would be nice if Akonadi server could handle this automatically.

I consider this major blocker that prevents us from ever suggesting PSQL as default.

dvratil created this task.Sep 15 2015, 3:50 PM
dvratil updated the task description. (Show Details)
dvratil raised the priority of this task from to Low.
dvratil added a project: KDE PIM.
dvratil moved this task to Backlog on the KDE PIM board.
dvratil added a subscriber: dvratil.
knauss closed this task as Resolved.Sep 1 2019, 3:41 PM
knauss claimed this task.
knauss added a subscriber: knauss.

The task was released with Applications 19.08.

elvisangelaccio added a comment.Sep 1 2019, 3:56 PM

Nice! Does this mean that we can start to use PSQL as backend?

dvratil added a comment.Sep 2 2019, 7:54 AM

@elvisangelaccio PSQL has been officially supported as an Akonadi backend since forever, it's just that major upgrade of Postgres required the user to perform tedious manual upgrade/migration of the data - this task was only about Akonadi being able to detect and perform the upgrade on its own without user intervention.

While I think that Postgres works much better than MySQL, for some reason I still feel uneasy about switching the defaults...