Skip to content

PITR fails due to wrong postgres password  #256

@benwaffle

Description

@benwaffle

While reproducing #255, after updating /data/postgresql/postgresql.user.conf with max_connections = 320 to try to fix it, I'm now seeing:

2024-08-12T20:00:21Z app[3d8dd719a93e78] iad [info]postgres | 2024-08-12 20:00:21.356 UTC [399] FATAL:  password authentication failed for user "postgres"
2024-08-12T20:00:21Z app[3d8dd719a93e78] iad [info]postgres | 2024-08-12 20:00:21.356 UTC [399] DETAIL:  Connection matched file "/data/postgresql/pg_hba.conf" line 8: "host all all ::0/0 md5"
2024-08-12T20:00:21Z app[3d8dd719a93e78] iad [info]failed post-init: failed to establish connection to local node: failed to connect to `host=fdaa:1:a290:a7b:2f8:8a7c:7dab:2 user=postgres database=postgres`: failed SASL auth (FATAL: password authentication failed for user "postgres" (SQLSTATE 28P01)). Retrying...
2024-08-12T20:00:21Z app[3d8dd719a93e78] iad [info][WARN] `postgres` user password does not match the `OPERATOR_PASSWORD` secret
2024-08-12T20:00:21Z app[3d8dd719a93e78] iad [info][WARN] Use `fly secrets set OPERATOR_PASSWORD=<password> --app db10` to resolve the issue

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions