EcoStruxure IT forum
A support forum for Data Center Operation, Data Center Expert, and EcoStruxure IT product users to share knowledge on installation, configuration, and general product use.
Posted: 2022-01-24 01:58 PM
Seeking input and guidance... regarding how ITA manages the ETL databases (we run ours internal) serving our external integrations. Folks familiar with the ITA GUI to create ETL jobs know that you cannot re-use the same "etluser_name" for multiple configurations.
As you create multiple ETL jobs on your ITA... there comes a need, to be able to configure one of the accounts created to have full access to all the others. So far (not being a DBA) i have found the settings are kept here
/etc/isx-operations/postgresql/pg.hba.conf
What I have noticed, any changes made to this file are wiped out when we reboot the host... or add a new ETL job. What I need to know is how/where we make the neccessary changes to ensure our additional permissions are never removed?
Posted: 2022-01-25 03:30 AM
Hello Wes, I will follow-up with you with a direct email.
Regards
Greg Sterling
Posted: 2022-02-04 07:20 AM
Closing the loop on this post... If making custom edits to the postgres user accounts, to ensure changes stick around after reboot or when new ETL jobs are added, add the needed changes to the template file which sits in the same directory.
/etc/isx-operations/postgresql/pg.hba.conf.template
Although I will also add... the driver behind this request was to streamline a stored procedure. Turns out we were able to leverage the default accounts. Altering permissions was not required. To do this, we enabled the DB extension "dblink" and got it all working.
Fun stuff!
😃
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.