there are different ways to achive this. If HA is really required, you could use our patroni module to spin up a postgresql cluster