Support Questions
Find answers, ask questions, and share your expertise

Unable to connect to postgresql with special characters in password using NIFI 1.3.0 with QueryDatabase Processor

Contributor

Trying to query Postgresql using NIFI 1.3.0 . Postgresql password has special characters in it. for ex : ABCD$$#

5 REPLIES 5

Super Guru

@manisha jain

Can you try keeping 4 $ signs in the password because double "$$" got mapped to "$" for backwards compatibility

EX:-

ABCD$$$$#

Contributor

Not working when there is # in the password .

Otherwise , when the password is like ABCD$$ ,It works by using ABCD$$$$

Is there a way to handle or escape '#' character .

Contributor

Please see the comment above .. @Shu

Mentor

@manisha jain

Why don't you just reset the password

That's the easiest solution !!


Contributor

Cannot reset the password ,please suggest a solution or can this be raised as a Bug to Nifi Community.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.