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

[#1]

[#2 · Accepted solution]

@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...

https://stackoverflow.com/questions/64210167/unable-to-connect-to-postgres-db-due-to-the-authenticat...

[#3]

Thanks a lot for your response.