![]() v /var/lib/openproject/pgdata-next:/var/openproject/pgdata-next \ v /var/lib/openproject/pgdata:/var/openproject/pgdata \ This volume will contain the upgraded cluster: docker run -rm -it \ ![]() We will also map a local folder named /var/lib/openproject/pgdata-next to a special volume in the container, named /var/openproject/pgdata-next. In this case, we assume that your existing PostgreSQL data is stored on the host at /var/lib/openproject/pgdata. Once the docker has stopped, you are ready to run the upgrade command. We can finally switch the old postgres folder with the upgraded one and restart the container.įirst, ensure that you have stopped your container: docker stop openproject This will generate an upgraded cluster in another folder. Then the goal is to take this folder, and apply pg_upgrade on it. 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. Migrating your OpenProject installation to PostgreSQL 13 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |