Skip to content
This repository was archived by the owner on Aug 22, 2024. It is now read-only.
This repository was archived by the owner on Aug 22, 2024. It is now read-only.

Pgscv ignores databases regular expression when tries to discover pg_stat_statements extension #45

@nazipov

Description

@nazipov

Describe the bug
Pgscv ignores databases regular expression when tries to discover pg_stat_statements extension. https://github.com/lesovsky/pgscv/blob/master/internal/collector/config.go#L185

Steps to reproduce
Add aws rds to dictionary services.

Expected behavior
Pgscv should check that database match with regex on pg_stat_statements discovering before connecting to this database.

pgSCV startup options
Config file

listen_address: 127.0.0.1:9890
autoupdate: off
no_track_mode: false
databases: "^(app_database_1|app_database_2)$"
services:
  "aws_rds":
    service_type: "postgres"
    conninfo: "postgres://pgscv:XXXXXX@rds-host/postgres"

Errors and Logs
Aws rds logs

2022-11-12 17:00:54 UTC:10.2.10.20(49376):pgscv@rdsadmin:[28030]:FATAL: pg_hba.conf rejects connection for host "X.X.X.X", user "pgscv", database "rdsadmin", SSL on

Pgscv logs

{"level":"warn","service":"pgscv","time":"2022-11-17T14:00:55Z","message":"connect to database 'rdsadmin' failed: failed to connect to `host=rds-host user=pgscv database=rdsadmin`: server error (FATAL: pg_hba.conf rejects connection for host \"X.X.X.X\", user \"pgscv\", database \"rdsadmin\", SSL on (SQLSTATE 28000)); skip"}

Additional context
It's not critical issue, but such kind of behavior creates a lot of flood in aws rds logs and it's not possible to fix it.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions