Hi everyone,
I’m currently running Frappe (version-15) on PostgreSQL 14 and I’m planning to upgrade to a newer version, ideally jumping to v18, though I’d also like to understand the incremental path through v15 and v16 if that’s the safer route.
Before I proceed, I wanted to check with the community on a few things:
Official support status — Does Frappe Framework officially support PostgreSQL versions beyond 14?
Known issues or breaking changes — Has anyone encountered query behavior changes, compatibility issues with Frappe’s ORM, or any migration-related problems when upgrading PostgreSQL on an existing Frappe installation?
Recommended upgrade path — Is it advisable to jump directly from v14 to v17/v18, or is a step-by-step upgrade (14 → 15 → 16 → 17 → 18) considered safer in the context of Frappe?
Impact on bench and database migrations — Does the PostgreSQL version affect how bench migrate or bench restore behaves? Any pg_dump/pg_restore caveats to be aware of?
Frappe version upgrade alongside PostgreSQL — I’m also considering upgrading Frappe from v15 to v16 around the same time. Is it recommended to do both upgrades together or separately? Could upgrading Frappe to v16 introduce any additional PostgreSQL compatibility requirements or conflicts that I should be aware of beforehand?
Production experience — If anyone has already upgraded in a production environment, I’d love to hear about your experience; smooth or painful!
Any guidance, documentation pointers, or real-world experience would be really appreciated. Thanks in advance!