Options for Postgres Support

[DonaldChung-HK]

Describe The Problem To Be Solved
I am trying to deploy a distributed IAM and running a HA and Postgres seems to offer better distributed DB options such as CockrochDB and I was wondering if it would be possible to adapt the code for that.

Solution suggestion

• Details of the technical implementation
  • Add spring postgres dependency
  • review any incompatibility in iam-persistent in spring data model
• Tradeoffs made in design decisions
  • Core data type may require overhaul for example indexer
  • Flyway schema needs to be upgraded
• Caveats and considerations for the future
  • May need to provide migration script for current MySQL users