Supported PostgreSQL Versions
Local installations of Flow Production Tracking are no longer offered. This documentation is intended only for those with existing instances of Shotgun Enterprise Docker. Click here for a list of our current offerings.
THIS SUPPORT MATRIX APPLIES TO ENTERPRISE DOCKER. ENTERPRISE CLASSIC DOES NOT SUPPORT POSTGRESQL 11.
| Flow Production Tracking / Flow Production Tracking Versions | Supported PostgreSQL Versions | Recommended PostgreSQL Version |
|---|---|---|
| 8.11 and above | PostgreSQL 12.x PostgreSQL 11.x PostgreSQL 9.6.x |
PostgreSQL 12.x |
| 7.11 - 8.10 | PostgreSQL 9.6.x | PostgreSQL 9.6.x |
| 7.x (prior to 7.11) | PostgreSQL 9.6.x PostgreSQL 9.3.x PostgreSQL 9.2.x |
PostgreSQL 9.6.x |
| 6.x | PostgreSQL 9.6.x PostgreSQL 9.3.x PostgreSQL 9.2.x* PostgreSQL 9.1.x* |
PostgreSQL 9.6.x |
* While supported, some performance impacts may be observed
FAQ
Why isn't PostgreSQL 9.1.x and earlier supported for 7.x?
The oldest version currently supported by PostgreSQL is 9.2. Flow Production Tracking may still run on older versions, but since these version are now at end-of-life and do not receive any security fixes, we are highly recommending you update to the latest supported version. See PostgreSQL Versioning Policy for more details.
What are the impacts of running PostgreSQL 9.2.x and earlier?
Older versions are known to miss important performance improvements. A Flow Production Tracking cluster running on an older version can be significantly slower.
9.2.x is also missing a lock acquisition timeout failure that can cause Flow Production Tracking be unavailable for a long period when adding a field on an entity in Flow Production Tracking. Such a situation can create significant downtime and updating to a newer version of PostgreSQL is highly recommended.