Assuming you followed the standard installation procedure, the folder (within the docker container) containing your PostgreSQL data will be located at /var/openproject/pgdata. The newer version of OpenProject includes an utility to automatically perform the upgrade for you. Remember that you need to have checked out that repository and work in the compose directory for the instructions to work. You can find the upgrade instructions for your docker-compose setup in the openproject-deploy repository. If everything is fine, you can then remove your older PostgreSQL installation:įor Debian/Ubuntu: sudo rm -rf /var/lib/postgresql/10/mainįor RedHat/CentOS: sudo rm -rf /var/lib/pgsql/10/data Sudo su - postgres -c "/usr/pgsql-13/bin/pg_ctl stop -wait -pgdata=/var/lib/pgsql/13/data"įor Debian/Ubuntu: sudo su - postgres Information” section. Sudo su - postgres -c "/usr/lib/postgresql/13/bin/pg_ctl stop -wait -pgdata=/var/lib/postgresql/13/main"įor RedHat/CentOS: sudo su - postgres -c "/usr/pgsql-10/bin/pg_ctl stop -wait -pgdata=/var/lib/pgsql/10/data" 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. Any help would be appreciated.Migrating your OpenProject installation to PostgreSQL 13 Now, in the log it says that I have to upgrade the clusters with pg_upgradecluster, but I really don’t know what that means. I have added the postgresql-13 and postgresql-client-13 packages, here is the. Please install the latest packages (postgresql-13 and postgresql-client-13) and upgrade the existing clusters with pg_upgradecluster (see manpage). The PostgreSQL version 9.4 is obsolete, but the server or client packages are still installed. It works fine so far, but now I get this warning in the build-run log when I run the travis_apt_get_update command: I have some issues with the TravisCI platform when I try to test the code when Pull Requesting some changes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |