On Wednesday, 1 November 2023 19:12:29 GMT mh@mike.franken.de wrote:
On Mittwoch, 1. November 2023 19:59:36 CET Ianseeks wrote:
On Wednesday, 1 November 2023 18:38:34 GMT mh@mike.franken.de wrote:
On Mittwoch, 1. November 2023 19:07:34 CET Ianseeks wrote:
On Wednesday, 1 November 2023 16:56:04 GMT mh@mike.franken.de wrote:
On Mittwoch, 1. November 2023 16:34:07 CET Ianseeks wrote:
ServerPath=/usr/bin/pg_ctl
What version is /usr/bin/pg_ctl? Perhaps you have to change this to something like /usr/lib/postgresql[xx]/bin/pg_ctl?
its pointing to /usr/lib/postgresql16/bin/pg_ctl
what is correct according to your description. Just to be sure: You followed https://userbase.kde.org/Akonadi/postgres_update
There are no instructions on that page apart from this message "There is currently no text in this page. You can search for this page title in other pages, or search the related logs, but you do not have permission to create this page."
uhm, sorry: https://userbase.kde.org/Akonadi/Postgres_update
But it describes exactly, what you've done - and what my script does.
I wrote a small script doing this job, perhaps it can help you (no warranty though). Call it with "<script> 9 10" for example.
I did mine manually via scripts with one file per action. 1. Backup # stop akonadi akonadictl stop # copy cp -R $HOME/.local/share/akonadi/db_data $HOME/.local/share/akonadi/db_data_13 # rename mv $HOME/.local/share/akonadi/db_data $HOME/.local/share/akonadi/db_data_old
2. Create new DB /usr/lib/postgresql16/bin/initdb --pgdata=$HOME/.local/share/akonadi/db_data --lc-collate=en_US.UTF-8 --locale=en_US.UTF-8
Not sure, though, if you can skip the versions in between.
I thought that too because i came across that problem in my early update of ver 9.6 to ver 11 but it looks like they've fixed that problem
3. Check upgrade /usr/lib/postgresql16/bin/pg_upgrade -b /usr/lib/postgresql13/bin -B /usr/lib/ postgresql16/bin -d $HOME/.local/share/akonadi/db_data_13 -D $HOME/.local/ share/akonadi/db_data --check
4. Do the upgrade if "3" worked okay /usr/lib/postgresql16/bin/pg_upgrade -b /usr/lib/postgresql13/bin -B /usr/lib/ postgresql16/bin -d $HOME/.local/share/akonadi/db_data_13 -D $HOME/.local/ share/akonadi/db_data
This all worked fine. I cannot understand where it thinks that the new DB was created by version 9.6
I already read the thread in the other list and I am really clueless now, what might have happened 8-( I did it lots of times and never had a problem. me too. it seems there is a config somewhere thats not being updated by the update Bye. Michael.
Thanks for taking the time to check it out. opensuse:tumbleweed:20231030 Qt: 5.15.11 KDE Frameworks: 5.111.0 - KDE Plasma: 5.27.9 - kwin 5.27.9 kmail2 5.24.2 (23.08.2) - akonadiserver 5.24.2 (23.08.2) - Kernel: 6.5.9-1- default - kernel-firmware-radeon 20231019