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 ? I wrote a small script doing this job, perhaps it can help you (no warranty though). Call it with "<script> 9 10" for example. ------------------------------------------------------- #!/bin/bash FROMVERSION="$1" case "$FROMVERSION" in [0-9]|[0-9][0-9]) ;; *) echo "usage: $0 <fromversion> <toversion>" exit 1 ;; esac TOVERSION="$2" case "$TOVERSION" in [0-9]|[0-9][0-9]) ;; *) echo "usage: $0 <fromversion> <toversion>" exit 1 ;; esac ACTL=/usr/bin/akonadictl [ -n "$ACTL" -a -x "$ACTL" ] || exit 2 # ToDo: check if running echo "$ACTL fsck" \ && "$ACTL" fsck \ && echo "$ACTL vacuum" \ && "$ACTL" vacuum \ && echo "$ACTL stop" \ && "$ACTL" stop \ && "$ACTL" status [ $? -ne 0 ] && exit 3 sleep 10 AHOME="$HOME/.local/share/akonadi/" cd "$AHOME" \ && echo "rm -rf db_data.psql${FROMVERSION}" \ && rm -rf db_data.psql${FROMVERSION} \ && echo "cp -R db_data db_data.psql${FROMVERSION}" \ && cp -R db_data db_data.psql${FROMVERSION} \ && echo "rm -rf db_data.work" \ && rm -rf db_data.work \ && echo "mv db_data db_data.work" \ && mv db_data db_data.work [ $? -ne 0 ] && exit 4 PSQLBINFROM="/usr/lib/postgresql${FROMVERSION}/bin/" PSQLBINTO="/usr/lib/postgresql${TOVERSION}/bin/" [ -d "$PSQLBINFROM" -a -d "$PSQLBINTO" ] || exit 5 echo "${PSQLBINTO}initdb --pgdata=./db_data --locale=C.UTF8" \ && "${PSQLBINTO}initdb" --pgdata=./db_data --locale=C.UTF8 \ && echo "${PSQLBINTO}pg_upgrade -b $PSQLBINFROM -B $PSQLBINTO -d ./ db_data.work -D ./db_data" \ && "${PSQLBINTO}pg_upgrade" -b "$PSQLBINFROM" -B "$PSQLBINTO" -d ./ db_data.work -D ./db_data \ && echo "${PSQLBINTO}vacuumdb --all --analyze-in-stages" \ && echo "-> not working because server is not running" [ $? -ne 0 ] && exit 6 echo "modify ~/.config/akonadi/akonadiserverrc before continuing ... " read var echo "$ACTL start" \ && "$ACTL" start \ && sleep 10 \ && echo "$ACTL fsck" \ && "$ACTL" fsck \ && echo "$ACTL vacuum" \ && "$ACTL" vacuum \ && "$ACTL" status [ $? -ne 0 ] && exit 7 ------------------------------------------------------------
Bye. Michael.
thanks