I'm experiencing issue working with ETL export database.
I successfully create internal export ETL database via web-interface and it works (I can see that in etl.log).
But I was unable to connect to database with pgAdmin tool:
I've found that port 5432 was closed and open it on firewall.
Now I have another error:
There were no entries in pg_hba.conf file related to new databese:
I add 'allow all' entry to pg_hba.conf file:
host all all all trust
and set parameter to listen all addresses in postgresql.conf file:
listen_addresses = '*'
But with no luck. I still receive error about connection rejection by pg_hba.
Can anyone advice how to configure new version to allow external connections? Is there something specific?
And why didn't ITA make all the settings when create export database?
Solved! Go to Solution.
Did you set an allowed list in the ETL definition in the web client? If not, then remote access is not allowed.
Did you mean this one?
I set it to 0.0.0.0, because usually it means allow all addresses.
It works for me either, thank you!
But nothing changes in pg_hba.conf and it is very interested...
So, now we need to add all addresses we want to connect from. Of course it is more secure,but less convenient for me 🙂
Sounds great, that it worked for you as well.
I could reproduce similar experience (as you) using pgAdmin but not with DbVisualizer. So basically we may add a specific IP to the allowed list when/if needed.
Discuss challenges and get support in energy and automation with 30,000+ experts and peers.
Over 10,000+ support articles are available to help you find answers to your product and business challenges.
Find peer based solutions to your questions. Provide answers for fellow community members!