GoCD h2db migration to PostgresSQL

[Abdul Latif Siddiqui]

Hello Team,

We are using GOCD version 20.4.0 with h2db.
We are planning to migrate from h2 to Postgres by following the below documents.
https://docs.gocd.org/current/installation/upgrading_go/upgrade_to_gocd_20.5.0.html
https://extensions-docs.gocd.org/postgresql/current/enable/

Using a migration tool, the data is successfully migrated to Postgres on AWS rds version 10.8.
But are unable to point Postgres, gocd is not picking up the changes and still using h2db.

From the documentation, I can see this message  You can get the PostgreSQL add-on for GoCD by contacting support.

I'd like to check 3 things
1. Is postgres addon a paid version ?
2. How can I get Postgres addon ?
3. At the moment our gocd db properties file is placed in `/go-server/config/db.properties` is this the proper location to configure ?

[Chad Wilson]

Hiya

Please ignore anything at https://extensions-docs.gocd.org/ - we took the site down a few days ago because it is now causing confusion. This was the documentation for the old commercial add-ons and was left-up for the last 2 years to support previous customers while people migrated/upgraded to later versions. If you saw a message "You can get the PostgreSQL add-on for GoCD by contacting support" on that site, you can ignore it. If you saw it somewhere else, please share the link and we'll fix it 😀

To specifically answer your questions:

> 1. Is postgres addon a paid version ?

It used to be. It was fully open-sourced and integrated into core GoCD in 20.5.0 release in June 2020. The open-sourcing and "making free" of PostgreSQL support is one of the reasons a DB migration 20.4.0 -> 20.5.0 was necessary, and why the https://github.com/gocd/gocd-database-migrator tool was made available.

> 2. How can I get Postgres addon ?

It's not required. You already have PostgreSQL support built-in to GoCD 20.5.0+. 👍

> 3. At the moment our gocd db properties file is placed in `/go-server/config/db.properties` is this the proper location to configure ?

Probably not. 😀 If you are running (or testing an upgrade) from a container (which is my guess from the path you suggest) you'll want to mount or store the file into /godata/config/db.properties. I imagine that's why it's not picking it up. Normally in a container the /godata folder would be something you would have mounted as a persistent volume as this is where your config history, plugins, h2 database, logs etc are stored.

-Chad

--
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/a01557ab-e9a5-4b54-a5cb-e3d24db3c830n%40googlegroups.com.

[Sriram Narayanan]

On Thu, Oct 6, 2022 at 9:00 PM 'Abdul Latif Siddiqui' via go-cd <go...@googlegroups.com> wrote:

Please check what you have at /var/ib/go-server/config.

Is /go-server a custom installation location? If so, the  config directory should indeed be within /go-server. See https://docs.gocd.org/current/installation/install/server/zip.html in case your installation was via a zip file.

I'm assuming that you've followed the instructions here:

https://docs.gocd.org/current/installation/upgrading_go/upgrade_to_gocd_20.5.0.html#step-5-configure-dbproperties-for-your-gocd-server

[Abdul Latif Siddiqui]

Hi,

Thanks for the prompt response, and yes we have container-based installation for GoCD, we will try to upgrade it to 20.5.0 as recommended to use the PostgresSQL addon.

This is the location of the configuration:

/ $ ls -al /go-server/config/
total 8
drwxr-xr-x    1 go       root            27 Oct  7 08:49 .
drwxr-xr-x    1 root     root            53 May 28  2020 ..
-rw-r--r--    1 root     root           186 Oct  6 11:40 db.properties
-rw-rw-r--    1 go       root          1032 May 28  2020 logback-include.xml
/ $