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

Support PostgreSQL database

    XMLWordPrintable

    Details

    • Similar Issues:

      Description

      Support PostgreSQL database in addition to MySQL

        Attachments

          Activity

          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)
          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: