Metricbeat - PostgreSQL authentication method

Elastic Stack Beats
1

Hello,

I am trying to use postgresql module for metricbeat but I get the following error:

error in QueryStats: failed to obtain a connection with the database: pq: Ident authentication failed for user "postgres"

My PostgreSQL database is configured with the Ident authentication method:

# IPv4 local connections:
host    all             all             127.0.0.1/32            ident

And postgresql module config file is:

[root@system ~]# cat /etc/metricbeat/modules.d/postgresql.yml
# Module: postgresql
# Docs: https://www.elastic.co/guide/en/beats/metricbeat/7.8/metricbeat-module-postgresql.html

- module: postgresql
  metricsets:
    - database
    - bgwriter
    - activity
  period: 10s
  hosts: ["postgres://localhost:5432?sslmode=disable"]
  username: "postgres"
  #password: "password"

Is there any form to use Ident authentication with postgresql module?

thanks,
Arturo.

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.