Please consult the /upstream/ documentation, specifically https://github.com/prometheus-community/postgres_exporter?tab=readme-ov-file#running-as-non-superuser, i.e. grant the "pg_monitor" role to your user.
OpenPGP_signature.asc
Description: OpenPGP digital signature