AWS Aurora Postgres supports this to an extent with "clones". You can even clone cross-account. The same copy-on-write stuff applies, so they're relatively cheap and fast. I hope that Google's new AlloyDB will also support it.
https://aws.amazon.com/about-aws/whats-new/2019/07/amazon_au...
There are some annoying restrictions, though. You can only have a single cross-account clone of a particular db per account.