How do we use Postgresql, in GOCD, Since now it's no more as part of the commercial offering

[Ajay Choudhary]

I wanted to use Postgresql as DB for GOCD since we have large amount of pipelines and it needs frequent Data cleanup and some time they are very slow... How do we configure Postgresql and use as backed DB for GOCD, instead H2DB... any documentaion or steps to perform this....

Thanks

Ajay.

[Aravind SV]

Hello Ajay,

We had said all commercial plugins would be open-sourced. With Postgres support, there is an attempt do something a little different by adding support for it within GoCD directly. The database access and migration part of GoCD is also being changed to make it be possible to use other database systems such as MySQL.

The pull request is here: https://github.com/gocd/gocd/pull/7646

It is a work in progress and will likely be released in the next release or two. Please note that anyone who upgrades after it is released will need to run a data migration, even if they want to continue using H2. There will be documentation and tooling to help with it.

Cheers,
Aravind

PS: You should also see the rest of the plugins open-sourced starting this month. The first one will likely be the AWS elastic agent plugin.

[Ajay]

Thanks Aravind,

--
You received this message because you are subscribed to the Google Groups "go-cd" group.
To unsubscribe from this group and stop receiving emails from it, send an email to go-cd+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/go-cd/20200513063514.fobcsbzxvmj72fy3%40arvindsv.com.