PostgreSQL Support

[system]

It would be awesome if PostgreSQL support was added. I’ve gone through the source code and I realized that the code has a Provider Type in the code for PostgreSQL, but it has a CheckDBConnection function that basically says anything besides Sql Server, Compact, MySql etc is Unsupported, even though the Enum value for PostgreSQL (populated from the Npgsql DB Factory) is in the code.

I don’t think it would be difficult to Add the Npgsql package for the postgresSql provider as a dependency to the project then modify the factories to support using Npgsql,

However, myself and the company I work for don’t really have the resources to be managing are own copy of the source code.

But it would be a nice feature to support as all of our in house products and other sites etc all run in PostgreSQL.

---

This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/52896-postgresql-support

[maccarilab]

Hi, is there a support for PostgreSQL in the new Umbraco release? Can I run the Umbraco solution ‘corsjune’ in git with PostgreSQL and how ? ( GitHub - corsjune/Umbraco-CMS: The simple, flexible and friendly ASP.NET CMS used by more than 225.000 websites ). Best Regards

[sebastiaan (Sebastiaan Janssen ⚓)]

Umbraco does not support PostgreSQL and this is not on our roadmap at the moment. I wouldn’t recommend running a fork of Umbraco that hasn’t been updated for 10 years

Related thread:

Umbraco and Entity Framework instead of nPoco

Any idea on when this is likely to come? It was mentioned in November 2022 It would be really create to use other DB’s including PostgresSQL, which I believe replacing npoco with EF would facilitate this. It would be useful for non-x86 based systems too, that can’t natively run SQL.