Batch CLI script for creating PostgreSQL agents (4228222)

Is there a way to create many PostgreSQL agents at the same time in a batch process like with the CLI installer?

Please review the following steps to create multiple PostgreSQL agents.

1. Download the file attached to this KB article. Users must be logged into Supportlink to download this file.
2. Have a FglAM available with the PostgreSQLAgent package deployed to it.
3. Edit test.csv file with properties for agents to be created. Columns are in the following order:
   1. Host
   2. Port
   3. Database (for connection purposes)
   4. User
   5. Password
4. Edit PostgreSQLAgentBatchCreation.groovy variables at the top of script.
   1. csvFile (required) – File path to CSV file. Backslashes in Windows file paths need to be escaped with a second backslash.
   2. amName (required) – The name of the FglAM where the agents will be deployed. FglAM names are displayed on the Administration/Agents/Agent Managers dashboard.
   3. agentPrefix (optional) – Agent name prefix. Default format is PostgreSQLAgent_on_host_port.
5. Run script from Foglight bin directory with command: “fglcmd.bat -usr foglight -pwd foglight -cmd script:run -f PostgreSQLAgentBatchCreation.groovy”. Replace italicized user and password fields with credentials for administrative account on the Foglight server. If groovy script is not located in bin directory or the name has been changed, the file path to the script should be modified appropriately. On *nix systems, fglcmd executable will be a .sh file.
   1. If no errors are quickly reported, the script should be running normally. It will take some time to complete. You can check the progress on the Agent Status page as new agents are created.
6. Once script has finished, agents can be selected and activated or further modified from the Agent Status page.

Final notes:

1. Agents will not be created if an agent matching the generated name already exists. Therefore, new database servers can be added to the CSV file and the script run again without creating duplicate agents.
2. Other properties in these agents will automatically be created with their default values. Those default values can be altered before agent creation in the Agent Properties dashboard. After creation, one or more agents can be selected and their properties modified with the Edit Properties feature. Alternatively, agents can be deleted and created again.