I would just have Postgres running statically on some solid hardware. It’s easy to configure permissions and connections, too.

Not too hard to set up streaming replication for a hot standby if you wanna be sure (or offload some reads).

I use Postgres btw