Longhorn volumes automatically replicate to multiple nodes (configurable) and automatically move to the nodes whose pods need it.
A postgres database running on a single node will experience some downtime during (re)deployments or when moving across nodes, but should be pretty quick depending on the size of the database. For true HA database, CockroachDB is supposed to be compatible with postgres, but I haven't had a chance to play with it.