Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

NI FI problems with postgree server

Solved Go to solution

NI FI problems with postgree server

New Contributor

Hi, I'm newbie in NIFI and also in java services 

yesterday I downloaded nifi-1.10.0 bin version 

i run run-nifi.bin 

and after i started to work with NIFI 

I made a connection to postgree database but it doesn't work 

 also my colleague made the same thing and everything is ok.

what can goes wrong with my NI FI ? 

проблемс.jpg When I use this password in DBeaver  everything is OK.

what have I do to make it right way?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: NI FI problems with postgree server

Super Collaborator

You will need to add permissions in postgres to allow connection for this user from the NiFi host.  You should follow documentation for your version of postgres to complete these steps.  If this is a sandbox, or dev setup, I recommend working to give the postgres user "wildcard" or unlimited access from any host.  This will remove the requirement of mapping the user permission to a specific host (whatever the nifi host is).  Once you get the user opened up you can try to test access from NiFi again.

 

 

3 REPLIES 3

Re: NI FI problems with postgree server

Super Collaborator

You will need to add permissions in postgres to allow connection for this user from the NiFi host.  You should follow documentation for your version of postgres to complete these steps.  If this is a sandbox, or dev setup, I recommend working to give the postgres user "wildcard" or unlimited access from any host.  This will remove the requirement of mapping the user permission to a specific host (whatever the nifi host is).  Once you get the user opened up you can try to test access from NiFi again.

 

 

Re: NI FI problems with postgree server

New Contributor

Thank you!I resolved the problem

Highlighted

Re: NI FI problems with postgree server

Community Manager

I'm happy to see you resolved your issue. Please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. 

 

 

 

mark as solution button

 

 



Cy Jervis, Community Manager

Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

Learn more about the Cloudera Community:
Community Guidelines
How to use the forum
Don't have an account?
Coming from Hortonworks? Activate your account here