If you’re running Frappe/ERPNext—or any application built on Frappe—with a PostgreSQL database and frequently encountering this error:
Server Error
psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction blockPossible source of error: erpnext (app)
You can easily resolve it using frappe_pg:
https://github.com/excel-azmin/frappe_pg
This Frappe app provides comprehensive PostgreSQL compatibility patches, allowing ERPNext to run smoothly on PostgreSQL instead of MariaDB/MySQL.
Give it a try and share your feedback!
If you find any issues, feel free to open an issue on the repository—we’ll be happy to help.