OpenProject MySQL installation to a PostgreSQL installation

ajeet 2019-06-28 05:08:35 UTC #1

Keywords: OpenProject - Google Cloud Platform - How to - Upgrade
Description:
Hi,
I have installed OpenProject yesterday, and I saw a notification saying to upgrade to PostgreSQL . Is there any how-to guide for bitnami stacks for this ? I am a begineer in tech.

Thanks,
Ajeet

jota 2019-06-28 11:48:10 UTC #2

Hi @ajeet,

Where did you obtain that notification? We include MySQL in the Bitnami OpenProject stack and we do not have any guide to migrate the data from MySQL to PostgreSQL. If you want to do so, you will need to backup the database information by following this guide

https://docs.bitnami.com/google/apps/openproject/administration/backup-restore-mysql-mariadb/

and then import the data in PostgreSQL and configure the application to work with that new database.

ajeet 2019-06-28 14:14:53 UTC #3

Hi @jota

I saw this notification as soon as I open the newly installed openproject dashboard. It appeared as a pop up at the bottom of the screen, and also there was a link for this in the notification:

https://www.openproject.org/operations/migration-guides/migrating-packaged-openproject-database-postgresql/
Can you please verify if this is to be done as I don't want to do the unnecessary thing if that is not required.

Thanks so much for the support,
Ajeet

michiel 2019-07-01 09:32:48 UTC #4

Hi @ajeet,

That only applies if you've installed OpenProject using DEB/RPM packages which is not the case with Bitnami.

Please, click on if you think my answer was helpful

ajeet 2019-07-01 18:15:27 UTC #5

Thanks @michiel . Glad I won't need to do some extra steps using Bitnami

system 2019-07-15 18:15:26 UTC #6

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!