PostgreSQL Provider for Umbraco

ATTENTION: This is a community driven project and is not officially supported by Umbraco HQ.

All Umbraco Unit and Integration test are passing successfully.

I did my best to implement a PostgreSQL provider for Umbraco, but there might be some edge 
cases that I haven't covered yet. If you find any issues or have suggestions for 
improvements, please don't hesitate to reach out.

Install PostgreSQL Database

1. Download and install PostgreSQL (version 16, 17 or 18) from the official website or especially for Windwos.
2. Create a new database for Umbraco using the PostgreSQL command line or a GUI tool like pgAdmin. Follow my tutorial video.
3. Start debugging this solution [F5]
4. If not trusting databse certificate "SSL Mode" is set to VerifyCA during installation. But you can change this later on in the connection string in appsettings.json file. Read details: https://www.npgsql.org/doc/security.html?tabs=tabid-1
5. When you have prepared your PostgreSQL database, install the Our.Umbraco.PostgreSql package from NuGet and select PostgreSQL in the database step.

Documentation and Issue Tracker

You can find more details in the Documentation. If you find any issues or want to ask for features, please use the IssueTracker

Comments and contributions are very welcome!