Have a look at YugabyteDB. Fully distributed Postgres with geo data placement constraints, replication, read replicas, joins, triggers, Postgres extensions. It'

Have a look at YugabyteDB. Fully distributed Postgres with geo data placement constraints, replication, read replicas, joins, triggers, Postgres extensions. It's actual Postgres under the hood. They offer managed solutions but YugabyteDB can be self-hosted and the database is Apache 2 licensed. I'm unaffiliated with the company, happy user.