Postgres password authentication issue

[giterdone509]

Hey folks, I am getting the below errors in my db container. For context, I am trying to import TeslaFI data using this guide: https://docs.teslamate.org/docs/import/teslafi/. I got to the point of saving the .csvs to the import folder and restarting. Everything corrupted after that.

Given that the logs indicate a password issue, I have reset my password following this guide for my db: #2773.

I am on postgres version 16.

Any ideas how I can solve this?

Logs
024-11-04 22:37:15.117 UTC [1] LOG: starting PostgreSQL 16.4 (Debian 16.4-1.pgdg120+2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2024-11-04 22:37:15.117 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-11-04 22:37:15.117 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-11-04 22:37:15.119 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-11-04 22:37:15.142 UTC [28] LOG: database system was shut down at 2024-11-04 22:37:07 UTC 2024-11-04 22:37:15.170 UTC [1] LOG: database system is ready to accept connections 2024-11-04 22:39:38.011 UTC [51] FATAL: password authentication failed for user "teslamate" 2024-11-04 22:39:38.011 UTC [51] DETAIL: Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256" 2024-11-04 22:39:38.040 UTC [53] FATAL: password authentication failed for user "teslamate" 2024-11-04 22:39:38.040 UTC [53] DETAIL: Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256" 2024-11-04 22:39:38.054 UTC [52] FATAL: password authentication failed for user "teslamate" 2024-11-04 22:39:38.054 UTC [52] DETAIL: Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256" 2024-11-04 22:39:38.220 UTC [54] FATAL: password authentication failed for user "teslamate" 2024-11-04 22:39:38.220 UTC [54] DETAIL: Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256" 2024-11-04 22:39:38.284 UTC [55] FATAL: password authentication failed for user "teslamate" 2024-11-04 22:39:38.284 UTC [55] DETAIL: Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256" 2024-11-04 22:39:38.353 UTC [56] FATAL: password authentication failed for user "teslamate" 2024-11-04 22:39:38.353 UTC [56] DETAIL: Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256" 2024-11-04 22:39:38.429 UTC [58] FATAL: password authentication failed for user "teslamate" 2024-11-04 22:39:38.429 UTC [58] DETAIL: Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256" 2024-11-04 22:39:38.463 UTC [59] FATAL: password authentication failed for user "teslamate" 2024-11-04 22:39:38.463 UTC [59] DETAIL: Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256" 2024-11-04 22:39:38.472 UTC [57] FATAL: password authentication failed for user "teslamate" 2024-11-04 22:39:38.472 UTC [57] DETAIL: Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256" 2024-11-04 22:39:38.515 UTC [62] FATAL: password authentication failed for user "teslamate" 2024-11-04 22:39:38.515 UTC [62] DETAIL: Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256" 2024-11-04 22:39:38.535 UTC [60] FATAL: password authentication failed for user "teslamate" 2024-11-04 22:39:38.535 UTC [60] DETAIL: Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256" 2024-11-04 22:39:38.539 UTC [61] FATAL: password authentication failed for user "teslamate" 2024-11-04 22:39:38.539 UTC [61] DETAIL: Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256" 2024-11-04 22:39:38.573 UTC [63] FATAL: password authentication failed for user "teslamate" 2024-11-04 22:39:38.573 UTC [63] DETAIL: Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256" 2024-11-04 22:39:38.599 UTC [64] FATAL: password authentication failed for user "teslamate" 2024-11-04 22:39:38.599 UTC [64] DETAIL: Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256" 2024-11-04 22:39:38.621 UTC [65] FATAL: password authentication failed for user "teslamate" 2024-11-04 22:39:38.621 UTC [65] DETAIL: Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256" 2024-11-04 22:39:38.639 UTC [66] FATAL: password authentication failed for user "teslamate" 2024-11-04 22:39:38.639 UTC [66] DETAIL: Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256" 2024-11-04 22:39:38.655 UTC [67] FATAL: password authentication failed for user "teslamate" 2024-11-04 22:39:38.655 UTC [67] DETAIL: Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256"

Grafana

[giterdone509]

I tried about everything, no dice. Ended up just restoring a backup.