I cannot connect from adminer to postgresql

Question

I try to up postgresql and adminer via docker container. But from adminer I cannot enter to postgresql with password and user I whote.

SQLSTATE[08006] [7] FATAL: password authentication failed for user "root"

I tried all.

version: '3'

services:
  web:
    build: .
    environment:
      - APACHE_RUN_USER=www-data
    volumes:
      - ./blog:/var/www/html/
    ports:
      - 8080:80
    working_dir: /var/www/html/
  db:
    image: postgres
    restart: always
    environment:
      POSTGRES_PASSWORD: kisphp
      POSTGRES_USER: root
      POSTGRES_DB: kisphp
    ports:
      - "5432:5432"
    volumes:
      - ./postgres:/var/lib/postgresql/data
  adminer:
    image: adminer
    restart: always
    ports:
      - "6080:8080"

score 2 · Accepted Answer · answered May 15 '19 at 13:24

2

This docker-compose configuration works well.

Try recreating it from scratch:

Delete ./postgres folder
docker-compose stop
docker-compose down
docker-compose up -d

answered May 15 '19 at 13:24

Alex Pliutau

21,392
27
113
143

but Why I have to use ``` docker inspect container_name ``` to know the IP of postgres. Why I cannot set default localhost ? – Виктор Васильев May 15 '19 at 16:07
2

No, you don't have to, adminer is deployed to the same docker-compose network, so you should use `db` as the host name to connect. – Alex Pliutau May 16 '19 at 07:09
Thank you, Alex. I think the day then I start to understand docker will come soon. – Виктор Васильев May 16 '19 at 17:04
adminer connects well. But ````pgadmin4 could not translate host name "db" to address: Name does not resolve – Виктор Васильев May 18 '19 at 18:24

I cannot connect from adminer to postgresql

1 Answers1

Linked