Use a Postgres Operator to have a full featured database (update/bakup/replication/TLS)

As a Ryax developer, I want my internal database to be highly available and fully secured , so that I have HA for my customers.

It's important for:

• seemless postgres upgrade
• secure communications between services and the database
• Have full backup of the database
• provide high availability in case of node failure
• Have the posibility to see the state of the database at any point in time (using WAL based backups)
• better read performances

Recipes and tests

• create a simple loop that call the RYAX API
• Kill one of the node
• check that we do not have any downtime

Who to warn about this and how? nobody

What is it good for? Strategic, User Delight, Security

references

Available Operators

• https://cloudnative-pg.io/
• https://github.com/zalando/postgres-operator
• https://github.com/CrunchyData/postgres-operator