cardano-graphql icon indicating copy to clipboard operation
cardano-graphql copied to clipboard

password authentication failed for postgre

Open singledogzhwy opened this issue 2 years ago • 0 comments

Summary

I carefully followed instruction in READ.ME but after "docker-compose up -d" I keep getting

postgres_1 | 2022-12-15 02:56:26.827 UTC [410] FATAL: password authentication failed for user "postgres" postgres_1 | 2022-12-15 02:56:26.827 UTC [410] DETAIL: Password does not match for user "postgres". postgres_1 | Connection matched pg_hba.conf line 95: "host all all all md5"

in logs

Steps to reproduce the bug

  1. git clone
    --single-branch
    --branch 7.0.2
    --recurse-submodules
    https://github.com/input-output-hk/cardano-graphql.git
    && cd cardano-graphql

  2. DOCKER_BUILDKIT=1
    COMPOSE_DOCKER_CLI_BUILD=1
    RESTORE_SNAPSHOT=https://update-cardano-mainnet.iohk.io/cardano-db-sync/13/db-sync-snapshot-schema-13-block-8127593-x86_64.tgz
    docker-compose up -d --build &&
    docker-compose logs -f

  3. see postgres_1 | 2022-12-15 02:56:26.827 UTC [410] FATAL: password authentication failed for user "postgres" postgres_1 | 2022-12-15 02:56:26.827 UTC [410] DETAIL: Password does not match for user "postgres". postgres_1 | Connection matched pg_hba.conf line 95: "host all all all md5"

in logs

Actual Result

why is the password in ./placeholder-secrets/postgre_password wrong and cause this problem?

Expected Result

password authentication success

Environment

not needed

Platform

  • [X] Linux (Ubuntu)
  • [ ] Linux (Other)
  • [ ] macOS
  • [ ] Windows

Platform version

No response

Runtime

  • [ ] Node.js
  • [X] Docker

Runtime version

v10.19.0

singledogzhwy avatar Dec 15 '22 03:12 singledogzhwy