![]() On Mac for example, localhost will refer to the docker client. Note: Depending on your docker installation and networking, you may need to replace the hostname localhost in the database URLs with to access the docker host. This is either the default or if you set up a PostgreSQL installation above, use credentials for your installation you set up above. Pass in DATABASE_URL pointing to your new PostgreSQL database. # Pass into the container but replace mysql2 with note: Ensure that the URL starts with mysql://, not with mysql2:// ! The PostgreSQL DATABASE_URL Note down or copy the current MySQL DATABASE_URL # Will look something of the kind To run the migration part of the image, you will have to provide two environment files: The MYSQL_DATABASE_URL Next, create the database owned by the new user createdb -O openproject openproject Of course, please choose a strong password and replace the values in the following guide with it! createuser -W openproject We are going to assume in the following guide that password were ‘openproject’. Then, as the PostgreSQL user, create the system user for OpenProject. Once installed, switch to the PostgreSQL system user. apt-get install postgresql postgresql-contrib libpq-dev Please check if your distributed package is too old. OpenProject requires at least PostgreSQL 9.5 installed. These are generic apt-based installation steps, please adapt them appropriately for your distribution. If you want to set up a PostgreSQL installation database outside the container and not use the built-in database, please set up a PostgreSQL database now. In any case, you may also use the internally configured PostgreSQL instance of the docker container by using the DATABASE_URL a PostgreSQL database outside docker Set up a PostgreSQL databaseĭepending on your usage, you may want to set up an external PostgreSQL database to provide the container with connection details just like you did for MySQL. ![]() The Dockerfile comes with a built-in PostgreSQL migration script that will auto-run and inform you what to do. Please follow our backup and restore guides for Docker-based installations. Backing upīefore beginning the migration, please ensure you have created a backup of your current installation. ![]() This guide will migrate your all-in-one docker-based MySQL installation to a PostgreSQL installation using pgloader. Migrating your Docker OpenProject database to PostgreSQL ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |