Have you looked into things like CloudnativePG? https://cloudnative-pg.io/