Better late than never - this is a welcome alternative to Amazon's RDS support for postgresql, the lack of which has been the primary reason I've kept personal workloads off of Azure. I'm excited to take this for a spin!
Azure SQL Server has been great at work; operationally, it couldn't be simpler, and the point-in-time restore feature saved our bacon at least once. The only drawback has been... SQL Server itself. It's a solid performer, but T-SQL is a bear to work with. If MSFT can apply the same operations magic to postgres, they'll have a real winner on their hands.
Just curious, do you use .NET at work? If so, does it work well with Postgres? (eg; EntityFramework smoothness)
I recommend you take a look at LINQ to DB ( https://github.com/linq2db/linq2db ) instead of EF.