topic Re: Migration PostgreSQL 9 to 12 in Installing and Upgrading

Migration PostgreSQL 9 to 12

Yukeer — Fri, 15 Nov 2024 22:52:48 GMT

Hi,

we're currently facing an issue on the database source.

We made a migration from PostgreSQL 9.6 to 12.7. However, our Talend batch does not seem to work anymore. It shows this error during the database connection attempt :

Exception in component tPostgresqlOutput_2

org.postgresql.util.PSQLException: Les serveurs de version antérieure à 8.0 ne supportent pas les savepoints.

at org.postgresql.jdbc3.AbstractJdbc3Connection.rollback(AbstractJdbc3Connection.java:165)

...

I tried in tPostgresqlConnection to modify the DB Version from "Prior to v9" to "9.X" but it does nothing.

Would it be possible that Talend does not recognize the recent version of PostgreSQL ?

Any other hints to solve the issue would be appreciated. Thanks.

Update 1: When I disable savepoints in tPostgresqlOutput_2, it shows a new error :

Exception in component tPostgresqlOutput_2

org.postgresql.util.PSQLException: ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc

de la transaction

(commands ignored until end of transaction block)

Re: Migration PostgreSQL 9 to 12

jan_terje — Mon, 30 May 2022 10:49:33 GMT

Hi Yukeer,

If you are on an old version of Talend, it is very likely that the version of Talend is the cause for this problem.

I've been using Talend 7.3 and 8.0 with PostgreSQL 13, and I'm currently using PostgreSQL 14 with Talend 8.0.

Upgrading Talend is probably your only option.

BR,

Jan Terje

Re: Migration PostgreSQL 9 to 12

Yukeer — Mon, 30 May 2022 11:09:32 GMT

Thanks for your feedback

Re: Migration PostgreSQL 9 to 12

Anonymous — Tue, 31 May 2022 03:34:58 GMT

Hello,

Here is online documentation for talend open studio Data Integration 8.0 about: TalendHelpCenter: Supported Third-Party System/Database/Business Application Versions

Hope it helps.

Best regards

Sabrina

Re: Migration PostgreSQL 9 to 12

Yukeer — Tue, 31 May 2022 08:12:45 GMT

Hello, thank you for answering.

According to the doc, I assume that 8.0 is required to use PostgreSQL 12 (12.1 at least).