Why is the agent showing an error in my PostgreSQL discovery about authentication failed for user “postgres”?

The Postgres plug-in attempts to log into the database server using the username and password of postgres. In many installations, this is a default superuser and will work.