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

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.

Of course I will

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

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

Delivered in 3.7.0

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

I need to figure out a migration path, before switching

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.

Documentation: https://wiki.jenkins.io/display/JENKINS/Pipeline+Maven+Plugin#PipelineMavenPlugin-UsingaPostgreSQLDatabase(since3.7.0)

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