Nifi throwing SQLException after DB version update, same query worked in Nifi on older postgre version

hkh — Tue, 03 Oct 2023 13:11:21 GMT

Re: Nifi throwing SQLException after DB version update, same query worked in Nifi on older postgre version

cotopaul — Tue, 03 Oct 2023 13:45:51 GMT

@hkh, your post lacks all the minimum information required for anybody to help you out. Nevertheless, based on your error message, it seems that you are trying to connect to a PostgreSQL Database.

Now, as you mentioned, you did an upgrade at the database level, meaning that some aspects have changed in terms of configurations. Your error message stats clearly what the issue is where you need to look to have it solved.

Unfortunately, this has nothing to do with NiFi, but to how your DBA Team has configured your PostgreSQL Instance.

Have a look here:
https://stackoverflow.com/questions/67588076/why-do-i-get-error-type-10-authentication-not-supported-for-postgresql-13-even

https://stackoverflow.com/questions/64210167/unable-to-connect-to-postgres-db-due-to-the-authentication-type-10-is-not-suppor

hkh — Tue, 03 Oct 2023 18:00:13 GMT

Thanks a lot for your response.