Postgres support

ERPNext
1

Does ERPNext now support Postgres or not? I have looked around and read in a number of places are Postgres and 1000s of queries needed to be migrated. However, I haven’t been able to find definitive answer as to whether Postgres is officially supported or now.

In the overrides directory within the ERPNext repo, I do see compose.postgres.yaml file.
What Frappe team or the official contributors provide a clear response on this please?

Thanks

2

Override for postgres is there because, frappe framework supports postgres. No app in the open source world is using frappe + postgres and doing daily CI runs to showcase the reliability.

  • If something related to mariadb fails, there are official apps that will get affected and it will be fixed immediately.
  • If something related to postgres fails you are on your own.

Let the dead threads rest in peace :sweat_smile:! Using PostgreSQL as a database for ERPNext - #54 by revant_one

Some community efforts: PostgreSQL Compatibility for ERPNext: Meet frappe_pg

3

The progress on Postgres support is really exciting to see. Having a solid alternative to MariaDB makes the framework much more versatile for different infrastructure needs. I’m curious to see how the performance benchmarks compare once it’s fully stable.

4

Hi @gibiteyz and @gibiteyz

You can also check out Postgres Database Setup and query builder migration · frappe/frappe Wiki · GitHub (Pypika is db agnostic)

What i understand is that its not a priority for frappe to support it so it has been left to the community

In Frappe Build 2026 youtube I heard that many Banks (about 700) in India only want Postgres which could be a huge potential market

5

I require manurity in terms of Frappe + Postgres support. From this discussion, it is clear my only option (for now) is to stick to MariaDB until such a time when Postgres has mainstream support.

Thanks for all your responses.

Ciao