[JIRA] (JENKINS-57543) Support PostgreSQL database

28 views
Skip to first unread message

cleclerc@cloudbees.com (JIRA)

unread,
May 19, 2019, 2:46:02 AM5/19/19
to jenkinsc...@googlegroups.com
Cyrille Le Clerc created an issue
 
Jenkins / Improvement JENKINS-57543
Support PostgreSQL database
Issue Type: Improvement Improvement
Assignee: Cyrille Le Clerc
Components: pipeline-maven-plugin
Created: 2019-05-19 06:45
Priority: Major Major
Reporter: Cyrille Le Clerc

Support PostgreSQL database in addition to MySQL
Add Comment Add Comment
 
This message was sent by Atlassian Jira (v7.11.2#711002-sha1:fdc329d)

cleclerc@cloudbees.com (JIRA)

unread,
May 23, 2019, 4:42:01 PM5/23/19
to jenkinsc...@googlegroups.com
Cyrille Le Clerc started work on Improvement JENKINS-57543
 
Change By: Cyrille Le Clerc
Status: Open In Progress

cleclerc@cloudbees.com (JIRA)

unread,
May 25, 2019, 4:27:01 PM5/25/19
to jenkinsc...@googlegroups.com

cleclerc@cloudbees.com (JIRA)

unread,
May 26, 2019, 10:30:01 AM5/26/19
to jenkinsc...@googlegroups.com
Cyrille Le Clerc edited a comment on Improvement JENKINS-57543
 
Re: Support PostgreSQL database
Download: https://repo.jenkins-ci.org/releases/org/jenkins-ci/plugins/pipeline-maven/3. 6 7 . 15 0 -beta-1/pipeline-maven-3. 6 7 . 15 0 -beta-1.hpi

cleclerc@cloudbees.com (JIRA)

unread,
May 26, 2019, 5:51:01 PM5/26/19
to jenkinsc...@googlegroups.com
Cyrille Le Clerc commented on Improvement JENKINS-57543
 
Re: Support PostgreSQL database

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-beta-1.hpi. Please don't forget to install the PostgreSQL API plugin to load the postgresql driver in the classpath of Jenkins.

benoit.guerin@gmail.com (JIRA)

unread,
May 27, 2019, 3:05:02 AM5/27/19
to jenkinsc...@googlegroups.com
benoit guerin commented on Improvement JENKINS-57543
 
Re: Support PostgreSQL database

Of course I will

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

cleclerc@cloudbees.com (JIRA)

unread,
May 27, 2019, 6:27:02 AM5/27/19
to jenkinsc...@googlegroups.com
Change By: Cyrille Le Clerc
Status: In Progress Review

cleclerc@cloudbees.com (JIRA)

unread,
May 27, 2019, 6:27:02 AM5/27/19
to jenkinsc...@googlegroups.com
Cyrille Le Clerc commented on Improvement JENKINS-57543
 
Re: Support PostgreSQL database

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

cleclerc@cloudbees.com (JIRA)

unread,
May 27, 2019, 10:48:01 AM5/27/19
to jenkinsc...@googlegroups.com
Cyrille Le Clerc edited a comment on Improvement JENKINS-57543
 
Re: Support PostgreSQL database
[~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 -beta-1 . hpi|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]. Please don't forget to install the PostgreSQL API plugin to load the postgresql driver in the classpath of Jenkins.

cleclerc@cloudbees.com (JIRA)

unread,
May 27, 2019, 10:49:02 AM5/27/19
to jenkinsc...@googlegroups.com

benoit.guerin@gmail.com (JIRA)

unread,
May 27, 2019, 11:30:02 AM5/27/19
to jenkinsc...@googlegroups.com
benoit guerin commented on Improvement JENKINS-57543
 
Re: Support PostgreSQL database

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

I need to figure out a migration path, before switching

cleclerc@cloudbees.com (JIRA)

unread,
May 27, 2019, 11:35:01 AM5/27/19
to jenkinsc...@googlegroups.com
Cyrille Le Clerc commented on Improvement JENKINS-57543
 
Re: Support PostgreSQL database

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.

cleclerc@cloudbees.com (JIRA)

unread,
May 29, 2019, 10:10:03 AM5/29/19
to jenkinsc...@googlegroups.com

cleclerc@cloudbees.com (JIRA)

unread,
May 29, 2019, 10:11:01 AM5/29/19
to jenkinsc...@googlegroups.com
Change By: Cyrille Le Clerc
Status: In Review Closed
Resolution: Fixed
Reply all
Reply to author
Forward
0 new messages