next »

[Juan Pedro M.]

Hello,
Is Postgres 10 supported? I see on the supported platforms that  Genero 3.10 supports postgres 9.2 to 9.6. The reason I am asking is that  I have an application using Genero 3.0 using dbmpg_9 using postgres 10 client libraries and connecting to a postgres 10 database and it is running with no issues.

Thanks

Juan Pedro Martinez

[Sebastien F.]

Hello Juan,

PostgreSQL 10 is supported starting from Genero BDL version 3.10.

The platform support matrix needs to be updated, we have overlooked this, sorry.

Always consider reading the documention to double check:

See the "SQL DATABASES" table in the new features page:

http://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/fgl_whatsnew_310.html

The ODI driver to be used for PostgreSQL 9.x and 10 is dbmpgs_9 (needs libpq.so.5), as described here:

http://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_Connections_009.html

You will also find PostgreSQL database version information in the SQL Database Guide for PostgreSQL:

http://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_odiagpgs_001.html

Yes, using the ODI dbmpgs_9 driver from Genero 3.00 can work with PostgreSQL 10 client lib and server.
However, use this configuration at your own risk: It is not tested in our Genero 3.00 QA suite!

Simple question: Why don't you upgrade to Genero 3.10 ?

Seb

[Juan Pedro M.]

Hi Seb,
Thanks for info.
We are planning to move to 3.10 but the application I work on provides mostly  SOAP web services as a server and as client.Because of the XMLNILLABLE/XMLOPTIONAL changes in Genero 3.10, we are going to need to do quite a bit of code changes and testing, and that means we won't be able to update until we do a new product release.

Thanks

Juan Pedro Martinez

[Sebastien F.]

OK I can understand the constraints introduced by Web Services changes, hopefully it's not too much code modifications for you.

And once you have upgraded to Genero 3.10, you will benefit from new bug fixes and enhancements for PostgreSQL:

https://4js.com/support/issue/?id=&product=FGL&stat=CLOSED&fixed_in=3.10&words=PostgreSQL&Search=Search#startissue

Seb