How to create new site based on Postgres

[taherelhossin]

Hi, Wanna ask please if it's possible to create a new frappe site but based on PostgreSQL instead of the default, which is MariaDB?

[kumarraditya]

Yes with Postgres, am looking for as well. Any idea how to do it

[vinaymishraofficial]

This is not currently supported by Frappe Manager.

FM provisions a shared MariaDB 10.6 global-db, and its site-creation path is MariaDB-specific. The documented external-database workflow also supports MariaDB only; there is no fm create option for selecting PostgreSQL.

Although Frappe itself has PostgreSQL-related support, that does not mean FM can provision or manage a PostgreSQL-backed site. Supporting it would require changes to FM’s database service, site creation, backup/restore and migration code—not just an additional Bench flag.