ASP.NET Membership with PostgreSQL and dev.nauck.AspSQLProvider
You may want to try version 2.0.0 of the provider. It contains a bugfix the hosted environment detection in ASP.NET 4+
You can grap the latest build on NuGet.
Documentation is available on project wiki.