Can recommend the cnpg project https://github.com/cloudnative-pg/cloudnative-pg

It's a kubernetes operator for postgres with a pretty good range of features

Honestly I wish something of this standard existed for mysql - I'd never use RDS again by choice.