After the network issue yesterday, I restarted my machines and started noticing this error in the postgres logs (I don’t know if this is new or has always been logging this warning)
My app works fine and I can connect with pgadmin. no issues there. Just wondering what is this.
I tried updating the OPERATOR_PASSWORD secret as suggested, but that didn’t solve it.
2024-09-02T12:17:40.656 app[9185e743f1ee68] lax [info] failed post-init: failed to establish connection to local node: failed to connect to `host=XXXXXXXXXXXXXX user=postgres database=postgres`: failed SASL auth (FATAL: password authentication failed for user "postgres" (SQLSTATE 28P01)). Retrying...
2024-09-02T12:17:41.655 app[9185e743f1ee68] lax [info] postgres | 2024-09-02 12:17:41.655 UTC [20999] FATAL: password authentication failed for user "postgres"
2024-09-02T12:17:41.655 app[9185e743f1ee68] lax [info] postgres | 2024-09-02 12:17:41.655 UTC [20999] DETAIL: Connection matched pg_hba.conf line 8: "host all all ::0/0 md5"
2024-09-02T12:17:41.656 app[9185e743f1ee68] lax [info] [WARN] `postgres` user password does not match the `OPERATOR_PASSWORD` secret
2024-09-02T12:17:41.656 app[9185e743f1ee68] lax [info] [WARN] Use `fly secrets set OPERATOR_PASSWORD=<password> --app XXXXXXXXX` to resolve the issue