Details

    • Similar Issues:

      Description

      Support PostgreSQL database in addition to MySQL

        Attachments

          Activity

          cleclerc Cyrille Le Clerc created issue -
          cleclerc Cyrille Le Clerc made changes -
          Field Original Value New Value
          Status Open [ 1 ] In Progress [ 3 ]
          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 ?
          cleclerc Cyrille Le Clerc made changes -
          Status In Progress [ 3 ] In Review [ 10005 ]
          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)
          cleclerc Cyrille Le Clerc made changes -
          Status In Review [ 10005 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          Hide
          wannaknowmo Alexandre deville added a comment -

          Hi Cyrille,

          not sure if it is the right place to post... having some H2 locking connection refused issue in our PROD env.

          saw one of your post mentioning that we should switch to either mysql or postgres db.

          we created a postgres db(12.1), install the plugins via jcasc successfully. connection to the db was successful.

          when i kick off a simple jenkins job, i do not see any job history in the jenkins_build table.

          wondering what step i missed.

           

          all these tables are empty except version

          postgres=# \dt

                              List of relations

          Schema |             Name             | Type  |  Owner   

          ----------------------------------------+---------

          public | generated_maven_artifact     | table | postgres

          public | jenkins_build                | table | postgres

          public | jenkins_build_result         | table | postgres

          public | jenkins_build_upstream_cause | table | postgres

          public | jenkins_job                  | table | postgres

          public | jenkins_master               | table | postgres

          public | maven_artifact               | table | postgres

          public | maven_dependency             | table | postgres

          public | maven_parent_project         | table | postgres

          public | version                      | table | postgres

          Show
          wannaknowmo Alexandre deville added a comment - Hi Cyrille, not sure if it is the right place to post... having some H2 locking connection refused issue in our PROD env. saw one of your post mentioning that we should switch to either mysql or postgres db. we created a postgres db(12.1), install the plugins via jcasc successfully. connection to the db was successful. when i kick off a simple jenkins job, i do not see any job history in the jenkins_build table. wondering what step i missed.   all these tables are empty except version postgres=# \dt                     List of relations Schema |             Name             | Type  |  Owner    ------- ---------------------------- ----- + --------- public | generated_maven_artifact     | table | postgres public | jenkins_build                | table | postgres public | jenkins_build_result         | table | postgres public | jenkins_build_upstream_cause | table | postgres public | jenkins_job                  | table | postgres public | jenkins_master               | table | postgres public | maven_artifact               | table | postgres public | maven_dependency             | table | postgres public | maven_parent_project         | table | postgres public | version                      | table | postgres

            People

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

              Dates

              • Created:
                Updated:
                Resolved: