Details

    • Similar Issues:

      Description

      Support PostgreSQL database in addition to MySQL

        Attachments

          Activity

          Show
          cleclerc 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
          Hide
          cleclerc Cyrille Le Clerc added a comment - - edited

          benoit guerin 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.

          Show
          cleclerc Cyrille Le Clerc added a comment - - edited benoit guerin 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.
          Hide
          falcon 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 ?

          Show
          falcon 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 ?
          Hide
          cleclerc Cyrille Le Clerc added a comment -

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

          Show
          cleclerc Cyrille Le Clerc added a comment - benoit guerin unfortunately, we don't have a migration tool for the moment.
          Hide
          cleclerc Cyrille Le Clerc added a comment -

          Delivered in 3.7.0

          Show
          cleclerc Cyrille Le Clerc added a comment - Delivered in 3.7.0
          Hide
          falcon 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

          Show
          falcon 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
          Hide
          cleclerc Cyrille Le Clerc added a comment -

          Thanks benoit guerin, 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.

          Show
          cleclerc Cyrille Le Clerc added a comment - Thanks benoit guerin , 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.
          Show
          cleclerc Cyrille Le Clerc added a comment - Documentation: https://wiki.jenkins.io/display/JENKINS/Pipeline+Maven+Plugin#PipelineMavenPlugin-UsingaPostgreSQLDatabase(since3.7.0)

            People

            • Assignee:
              cleclerc Cyrille Le Clerc
              Reporter:
              cleclerc Cyrille Le Clerc
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: