What were you trying to do that didn't work?

The resource-agent pgsqlms requires that the system_user user does not require a password in order to access the postgresql database.

The issue is that there is no way to configure a username and password  for the pgsqlms resource-agent that will be used to monitor the postgresql database (that is seperate from the attribute system_user.

We are requesting attributes similar to the ones provided by pgsql for pgsqlms.

• monitor_user
• monitor_password
• Additional request for a password_script option (added by rhn-engineering-cfeist)

What is the impact of this issue to you?

Customer states this is security issue as password is not required for the postgresql  user.

Please provide the package NVR for which the bug is seen:

resource-agents-paf-4.10.0-71.el9_6.5.x86_64

How reproducible is this bug?:

Yes, as the options do not exist for the resource-agent.

Steps to reproduce

1.  None

Expected results

The resource-agent pgsqlms should have options for configuring a username and password for the postgresql database that will be used for monitoring. 

Actual results

There is no option the resource-agent pgsqlms for configuring a username and password for the postgresql database that will be used for monitoring.