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


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. OpenProject
  3. OpenProject & PostgreSQL

OpenProject & PostgreSQL

Scheduled Pinned Locked Moved Solved OpenProject
openproject
6 Posts 4 Posters 1.1k Views 5 Watching
  • 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.
    • luckowL Offline
      luckowL Offline
      luckow
      translator
      wrote on last edited by girish
      #1

      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
      1
      • girishG Offline
        girishG Offline
        girish
        Staff
        wrote on last edited by
        #2

        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
        0
        • yusfY Offline
          yusfY Offline
          yusf
          wrote on last edited by
          #3

          New app package planned then?

          1 Reply Last reply
          0
          • nebulonN Offline
            nebulonN Offline
            nebulon
            Staff
            wrote on last edited by
            #4

            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
            0
            • yusfY Offline
              yusfY Offline
              yusf
              wrote on last edited by
              #5

              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
              0
              • nebulonN Offline
                nebulonN Offline
                nebulon
                Staff
                wrote on last edited by
                #6

                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
                1
                Reply
                • Reply as topic
                Log in to reply
                • Oldest to Newest
                • Newest to Oldest
                • Most Votes


                  • Login

                  • Don't have an account? Register

                  • Login or register to search.
                  • First post
                    Last post
                  0
                  • Categories
                  • Recent
                  • Tags
                  • Popular
                  • Bookmarks
                  • Search