Task #2175
openOfficial support for postgresql 12
60%
Description
The main point of this ticket is to make postgresql 12 as official supported version.
Run automatic tests for all product modules against this version.
Test manually use cases which are in wiki.
Check postgresql release notes to find if there is something we should care about.
Update documentation with supported version.
Files
Updated by Roman Kučera over 4 years ago
- File Test Results - acc 11.html Test Results - acc 11.html added
- File Test Results - acc 12.html Test Results - acc 12.html added
- File Test Results - core 11.html Test Results - core 11.html added
- File Test Results - core 12.html Test Results - core 12.html added
- File Test Results - vs 12.html Test Results - vs 12.html added
- % Done changed from 0 to 50
Result of automatic test:
CORE:
postgres 11 - 53 failed, 42 ignored, 2350 passed
postgres 12 - 53 failed, 42 ignored, 2350 passed
failed tests are the same tests.
ACC:
postgres 11 - 8 failed, 11 ignored, 536 passed
postgres 12 - 7 failed, 11 ignored, 537 passed
failed test are the same tests. The only difference is IdentitySyncTest which failed on postgres 11 but not on postgres 12
RPT:
27 successful test for both DB versions
VS:
postgres 11 - ALL succesful
postgres 12 - 1 error, 1 ignored, 51 passed - failed test eu.bcvsolutions.idm.vs.service.impl.DefaultVsRequestServiceIntegrationTest#checkMultivalueInWishObjectTest
If you want to see whole results where some test failed see attached documents.
All tests were executed on local environment with IdM 10.1.0 and local database in docker containers(for each db version special container)
Next step is to manually test use cases from wiki.
Updated by Roman Kučera over 4 years ago
- % Done changed from 50 to 60
I manually test some basic use cases from https://wiki.czechidm.com/tutorial/dev/test-scenarios/produkt
Everything is working.
So now is probably save to say that postgres 12 is supported :)
Updated by Alena Peterová almost 4 years ago
Note: following message is written in the logs when starting IdM on PostgreSQL 12.5. But so far, we haven't find any problems with PostgreSQL 12 yet.
2021-01-25 11:57:33.783 WARN 85758 --- [main] o.f.c.i.database.base.Database.warn : Flyway upgrade recommended: PostgreSQL 12.5 is newer than this version of Flyway and support has not been tested.