Skip to main content
  • EN
  • Home
  • Forums
  • FME Flow
  • General
  • What versions of PostgreSQL are supported for readers and writers in FME Server 2020.2.3? We recently upgraded our on prem Postgres database to version 13.3 (PostGIS 3.1.2) and we're now receiving the following error on some jobs:

168

2021-7-12 06:41:15 | Destination Feature Type Routing Correlator (RoutingFactory): POSTGIS writer: Writer failed in open() call

 

167

2021-7-12 06:41:15 | POSTGIS writer: Writer failed in open() call

 

166

2021-7-12 06:41:15 | Writer failed to create table 'TABLE_NAME'. OIDs are not supported for PostgreSQL version 'PostgreSQL 13.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit'

(requires lower than PostgreSQL 12)

Update on our side:

 

It appears that rebuilding and republishing the workbench has solved this error. I'm still unclear on why the PostgreSQL upgrade caused this issue though. How can we tell in the future if our version of FME Server will support the database versions that we upgrade to?

Reply


Community Stats

30,352
Posts
115,344
Replies
38,087
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.