Project

General

Profile

Actions
Copy link

Task #2175

open

Official support for postgresql 12

Added by Roman Kučera about 4 years ago. Updated over 3 years ago.

Status:
In Progress
Priority:
Normal
Assignee:
Roman Kučera
Category:
Database
Target version:
-
Start date:
03/31/2020
Due date:
% Done:

60%

Estimated time:
Owner:

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

Download all files
Test Results - acc 11.html (4.11 MB) Test Results - acc 11.html Roman Kučera, 04/01/2020 10:12 AM
Test Results - core 11.html (2.73 MB) Test Results - core 11.html Roman Kučera, 04/01/2020 10:12 AM
Test Results - acc 12.html (4.08 MB) Test Results - acc 12.html Roman Kučera, 04/01/2020 10:12 AM
Test Results - vs 12.html (79.2 KB) Test Results - vs 12.html Roman Kučera, 04/01/2020 10:12 AM
Test Results - core 12.html (2.73 MB) Test Results - core 12.html Roman Kučera, 04/01/2020 10:12 AM
Actions
Copy link
 #1

Updated by Roman Kučera about 4 years ago

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.

Actions
Copy link
 #2

Updated by Roman Kučera about 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 :)

Actions
Copy link
 #3

Updated by Alena Peterová over 3 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.

Actions
Copy link

Also available in: Atom PDF