caseyandgina

I'm setting up some pg_cron jobs using Ansible, and was hoping to just call the `schedule_in_database` function on each deployment, as this will not create a job that already exists....

Can't use UNIX socket connection

6

`'user=app_sql_exporter dbname=postgres host=/run/postgresql port=5432'` ...results in: `{"caller":"job.go:189","err":"sql: unknown driver \"\" (forgotten import?)","job":"example","level":"warn","msg":"Failed to connect","ts":"2024-07-26T17:50:10.540688846Z"}` `'postgres://app_sql_exporter:testpw@%2Frun%2Fpostgresql:5432/postgres'` ...results in: `{"caller":"job.go:104","err":"parse \"postgres://app_sql_exporter@%2Frun%2Fpostgresql:5432/postgres\": invalid URL escape \"%2F\"","job":"example","level":"error","msg":"Failed to parse URL","ts":"2024-07-26T17:49:26.091765976Z","url":"postgres://app_sql_exporter@%2Frun%2Fpostgresql:5432/postgres"}` `'postgres://app_sql_exporter:testpw@/run/postgresql:5432/postgres'` ...results in: `{"caller":"job.go:189","err":"pq:...

Multi-target support issue with UNIX socket path encoding

1

I'd like to collect metrics like analyze/vacuum stats for tables in multiple databases, not just the one in the primary DSN. I'm trying to use multi-target support for this, but...