1 Nov
2023
1 Nov
'23
18:59
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."
> 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
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
> -------------------------------------------------------
> #!/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
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