Background
I have scripted the execution of pgdsat which set the password with PGPASSWORD variable pulled from keystore. I explicitly do not want to use the .pgpass for security reasons
Problem
Execution constantly prompts for the user password which is undesirable
Prompts for password as much as 60 times
Is this a bug or the normal behaviour?
Requirement
I need to be able to pass the password using the exported PGPASSWORD variable value within my scripts (or command line) to execute the tool
This will allow the rollout/execution to multiple clusters via single interface
Please advise
Thanks
Joseph
Background
I have scripted the execution of pgdsat which set the password with PGPASSWORD variable pulled from keystore. I explicitly do not want to use the .pgpass for security reasons
Problem
Execution constantly prompts for the user password which is undesirable
Prompts for password as much as 60 times
Is this a bug or the normal behaviour?
Requirement
I need to be able to pass the password using the exported PGPASSWORD variable value within my scripts (or command line) to execute the tool
This will allow the rollout/execution to multiple clusters via single interface
Please advise
Thanks
Joseph