[Bug] password authentication failed for user "postgres" / Role "postgres" does not exist.

[stebansaa]

Bug report

when using docker, everything works correctly for a few hours, then Postgres starts showing an error about an account that does not exist.  Tested with release 0.3.0 on ubuntu 20.04, and Docker 4.12.

Relevant log output

postgres_1    | 2023-03-24 21:42:44.141 UTC [93] FATAL:  password authentication failed for user "postgres"
postgres_1    | 2023-03-24 21:42:44.141 UTC [93] DETAIL:  
postgres_1    |         Connection matched pg_hba.conf line 100: "host all all all scram-sha-256"

IPFS hash

No response

Subgraph name or link to explorer

No response

Some information to help us out

• [ ] Tick this box if this bug is caused by a regression found in the latest release.
• [ ] Tick this box if this bug is specific to the hosted service.
• [X] I have searched the issue tracker to make sure this issue is not a duplicate.

OS information

Linux

[narendra-sajwani]

I have been trying to run a Graph Node locally built from source. I am running into some errors related to postgresql db ERRO Failed to connect notification listener: db error: FATAL: password authentication failed for user "nksajwani[", retry_delay_s: 1, attempt: 0, channel: store_events, component: NotificationListener

[aditya172926]

Hey @stebansaa adding on this issue. The cargo build is successful but I am facing the same issue with postgresql.

Currently using postgresql version 14.7

[NicoDFS]

Also getting this with the latest Docker build

[donut33-social]

Also getting this right now. Can it be solved?