Hey guys,
I was thinking about upgrading my postgres database to version 14. But since the upgrade process is kind of complicated I thought I can simply convert my exiting database to the new postgres 14 database, like I did when I switched from mariadb to postgres.
I have nextcloud running in an docker container in unraid and I am using the following command to convert the database:
occ db:convert-type --all-apps --port 55432 --clear-schema pgsql nextcloud 10.10.42.42 nextclouddb
But then I receive the following error message:
In ConvertType.php line 149:
Can not convert from pgsql to pgsql.
I already received the information from reddit I need the pg_dump and pg_restore commands here to simply backup the existing database and restore it to the new one.
Unfortunately I wasn't lucky to find a instruction on how to do it on unraid. I am not a professional so I have trouble figuring it out by myself/Google.
Has someone already switched from postgres 13.4 to 14 on unraid and can tell me the commands and where to type them in to update my postgres database?