Our Postgres Docker templates still use version 9.6. AFAIK migrations work in v11 but we should test this and bump our versions to v11.
Also, we should document what versions of PG we support in migrations
I have not checked this part of the project yet. Interested to take this one up later today. WDYT? @craicoverflow @wtrocki
We know that this update will cause issues and also we need to know what version we have in the kube rh envs before we migrate to 11 or 12. There should be some mention on v11 or v12 on knex side that might be blocked. This requires a lot of context to be done but it is nice to do some investigation etc. Let's chat about it first
We know that this update will cause issues and also we need to know what version we have in the kube rh envs before we migrate to 11 or 12.
Does it matter what version is in the RH environment? I would imagine the templates in this repo will not affect that, rather the docker-compose in DataSync Starter would be the place to ensure the versions match.
@craicoverflow Thanks to the contribution guidelines I'll be able to make this change and test it. I would like to solve this issue as part of the hacktoberfest event, Can you please assign this task to me?
Sure thing @ThirumlaDevi I have assigned you for now. Thanks!
~https://github.com/sclorg/postgresql-container images to use~
@ThirumlaDevi Ignore my coment use current docker image. We found that those images behave differently and it will require a lots of tests to get around.
@craicoverflow @wtrocki I have updated Docker PostgreSQL templates to use version 11.x and I have also tested the same.
I have explained this in detail in the below PR description ---> https://github.com/aerogear/graphback/pull/2154
Also can you please re-assign this task to me?
Fixed in #2154 - thanks again @ThirumlaDevi