Uploaded image for project: 'Jenkins'
  1. Jenkins
  2. JENKINS-57543

Support PostgreSQL database

XMLWordPrintable

      Support PostgreSQL database in addition to MySQL

          [JENKINS-57543] Support PostgreSQL database

          Cyrille Le Clerc created issue -
          Cyrille Le Clerc made changes -
          Status Original: Open [ 1 ] New: In Progress [ 3 ]

          Cyrille Le Clerc added a comment - - edited

          Download: https://repo.jenkins-ci.org/releases/org/jenkins-ci/plugins/pipeline-maven/3.7.0-beta-1/pipeline-maven-3.7.0-beta-1.hpi

          Cyrille Le Clerc added a comment - - edited Download: https://repo.jenkins-ci.org/releases/org/jenkins-ci/plugins/pipeline-maven/3.7.0-beta-1/pipeline-maven-3.7.0-beta-1.hpi

          Cyrille Le Clerc added a comment - - edited

          falcon as you "liked" https://github.com/jenkinsci/pipeline-maven-plugin/pull/214, could you test the PostgreSQL support using pipeline-maven-3.7.0. Please don't forget to install the PostgreSQL API plugin to load the postgresql driver in the classpath of Jenkins.

          Cyrille Le Clerc added a comment - - edited falcon as you "liked" https://github.com/jenkinsci/pipeline-maven-plugin/pull/214 , could you test the PostgreSQL support using pipeline-maven-3.7.0. Please don't forget to install the PostgreSQL API plugin to load the postgresql driver in the classpath of Jenkins.

          benoit guerin added a comment -

          Of course I will

          Just a question, is there any automatic migration path from embedded H2 to external MySQL / PostGreSQL ?

          benoit guerin added a comment - Of course I will Just a question, is there any automatic migration path from embedded H2 to external MySQL / PostGreSQL ?
          Cyrille Le Clerc made changes -
          Status Original: In Progress [ 3 ] New: In Review [ 10005 ]

          Cyrille Le Clerc added a comment -

          falcon unfortunately, we don't have a migration tool for the moment.

          Cyrille Le Clerc added a comment - falcon unfortunately, we don't have a migration tool for the moment.

          Cyrille Le Clerc added a comment -

          Delivered in 3.7.0

          Cyrille Le Clerc added a comment - Delivered in 3.7.0

          benoit guerin added a comment -

           Install
           Configuration (warning that PG 9.6 not officially supported, but connection successfull)

          I need to figure out a migration path, before switching

          benoit guerin added a comment -  Install  Configuration (warning that PG 9.6 not officially supported, but connection successfull) I need to figure out a migration path, before switching

          Cyrille Le Clerc added a comment -

          Thanks falcon, I didn't test PostgreSQL 9 but we use very very standard features. I found https://github.com/dimitri/pgloader to migrate data from MySQL to PostgreSQL but I didn't test.

          Cyrille Le Clerc added a comment - Thanks falcon , I didn't test PostgreSQL 9 but we use very very standard features. I found https://github.com/dimitri/pgloader to migrate data from MySQL to PostgreSQL but I didn't test.

            cleclerc Cyrille Le Clerc
            cleclerc Cyrille Le Clerc
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: