Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Solved OpenProject & PostgreSQL

    OpenProject
    openproject
    4
    6
    229
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • luckow
      luckow translator last edited by girish

      Since this version, OpenProject displays a banner for administrator accounts "Future versions of OpenProject will likely drop or reduce support for MySQL and MariaDB databases. Your installation is still running on MySQL and we suggest you migrate your installation to PostgreSQL. This process is easy when following our migration guides: Migrating your installation to PostgreSQL"
      Do we have a roadmap for this change? I've heard from some guys from drupal, that they need PostgreSQL because of migration tasks.

      Pronouns: he/him | Primary language: German

      1 Reply Last reply Reply Quote 1
      • girish
        girish Staff last edited by

        While it's possible to create update scripts to migrate db transparently, I think we would probably end up creating a new package and write up some instructions for users on how to migrate from mysql to postgresql.

        1 Reply Last reply Reply Quote 0
        • yusf
          yusf last edited by

          New app package planned then?

          1 Reply Last reply Reply Quote 0
          • nebulon
            nebulon Staff last edited by

            I am currently looking into https://www.openproject.org/operations/migration-guides/migrating-manual-openproject-database-postgresql/ however if this is taking too much time, we will release a new app package without the automatic migration, since the install volume of OpenProject is quite low. So far it is however also unclear how a manual migration can even look like.

            1 Reply Last reply Reply Quote 0
            • yusf
              yusf last edited by

              Good to know, as I plan on using OP but I'd rather wait for the PostgreSQL-backed version, if it's not too far down the line.

              1 Reply Last reply Reply Quote 0
              • nebulon
                nebulon Staff last edited by

                The new package with the migration steps included is actually done, however the migration itself is not working as expected. This requires further debugging before releasing.

                1 Reply Last reply Reply Quote 1
                • First post
                  Last post
                Powered by NodeBB