First, connect to your server and make sure your local version is PostgreSQL v10:įor Debian/Ubuntu: sudo cat /var/lib/postgresql/10/main/PG_VERSIONįor RedHat/CentOS: sudo cat /var/lib/pgsql/10/data/PG_VERSIONįor RedHat/CentOS: sudo yum install pgsql13įor Debian/Ubuntu: sudo su - postgres -c "/usr/lib/postgresql/10/bin/pg_ctl stop -wait -pgdata=/var/lib/postgresql/10/main".For the documentation parts titled RedHat/CentOS RedHat Enterprise Linux 8 was used. NOTE: RedHat and CentOS are slightly different, depending on which PostgreSQL package/repository will be used. In the following, we assume that you initially let OpenProject setup your PostgreSQL installation, using a local database. Please adapt that guide or the following steps to your distribution. A guide we can recommend for Debian/Ubuntu based servers is this one. In this case, please follow the instructions from your provider or use generic PostgreSQL upgrade guides. If that is not the case, you are likely using a self-provisioned database or a remote database. To do that, please run the following command: sudo cat /etc/openproject/installer.dat | grep postgres/autoinstallĪnd verify that it outputs: postgres/autoinstall install.
Only PostgreSQL installations that were installed by the OpenProject package are applicable to this guide. Please first check whether this guide applies to you at all.
Before attempting the upgrade, please ensure you have performed a backup of your installation by following the backup guide. Please follow this section only if you have installed OpenProject using this procedure. If you have an existing OpenProject installation, please follow the guide below to upgrade your PostgreSQL version. OpenProject version 12+ will default to PostgreSQL 13.
Migrating your OpenProject installation to PostgreSQL 13
0 kommentar(er)
