|
Title: Postgres 10 Post by: Juan Pedro M. on April 18, 2018, 08:27:34 pm 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 Title: Re: Postgres 10 Post by: Sebastien F. on April 19, 2018, 09:25:17 am 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 Title: Re: Postgres 10 Post by: Juan Pedro M. on April 19, 2018, 02:35:54 pm 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 Title: Re: Postgres 10 Post by: Sebastien F. on April 19, 2018, 03:11:59 pm 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 |