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.
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. Bye. Michael.