geometria
@geometria

Как установить Postgres в контейнер Docker?

В браузере с проектом postgres:
Connection error: SQLSTATE[08006] [7] could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432? could not connect to server: Address not available Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432?


В логах докер-контейнера:
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.


2021-02-27 15:42:35.809 GMT [1] LOG:  input in flex scanner failed at file "/etc/postgresql.conf" line 1
2021-02-27 15:42:35.809 GMT [1] FATAL:  configuration file "/etc/postgresql.conf" contains errors


PgAdmin намекает на отсутсвие пользователя:
603b64061e14b488282336.png

команда
docker-compose exec postgres psql -U postgres
выдает
Container 212bf5... is restarting, wait until the container is running


а такая
docker-compose run --rm postgres psql -U postgres
выдает
psql: error: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?


мой docker-compose.yml
php:
    build:
      context: .
      dockerfile: php.dockerfile
    container_name: php
    volumes:
      - ./src:/var/www/html:delegated
    networks:
      - laravel

  postgres:
    image: 'postgres:latest'
    container_name: postgree
    restart: 'always'
    environment:
      POSTGRES_DB: db_pg
      POSTGRES_USER: user
      POSTGRES_PASSWORD: password
    ports:
      - 5432:5432
    volumes:
      - ./postgres/conf/postgresql.conf:/etc/postgresql.conf
    command: postgres -c config_file=/etc/postgresql.conf
    networks:
      - laravel

  phppgadmin:
    image: 'dockage/phppgadmin:latest'
    container_name: phppgadmin
    restart: 'always'
    ports:
      - '8090:80'
    depends_on:
      - postgres
    links:
      - postgres
    environment:
      PHP_PG_ADMIN_SERVER_DESC: PostgreSQL
      PHP_PG_ADMIN_SERVER_HOST: pgsql
      PHP_PG_ADMIN_SERVER_PORT: 8090
      PHP_PG_ADMIN_SERVER_SSL_MODE: allow
      PHP_PG_ADMIN_SERVER_DEFAULT_DB: db_pg
      PHP_PG_ADMIN_SERVER_PG_DUMP_PATH: /usr/bin/pg_dump
      PHP_PG_ADMIN_SERVER_PG_DUMPALL_PATH: /usr/bin/pg_dumpall
    networks:
      - laravel


php.dockerfile
FROM php:7.4-fpm-alpine

RUN apk update && apk add \
    postgresql-dev


RUN docker-php-ext-install pdo pdo_mysql
RUN docker-php-ext-install pdo pdo_pgsql


ADD ./php/www.conf /usr/local/etc/php-fpm.d/www.conf
RUN addgroup -g 1000 laravel && adduser -G laravel -g laravel -s /bin/sh -D laravel
RUN mkdir -p /var/www/html
RUN chown laravel:laravel /var/www/html
WORKDIR /var/www/html


Подскажите, как исправить?
  • Вопрос задан
  • 127 просмотров
Пригласить эксперта
Ответы на вопрос 1
sergey-gornostaev
@sergey-gornostaev Куратор тега PostgreSQL
Седой и строгий
Исправить ошибки конфигурации постгреса.
Ответ написан
Ваш ответ на вопрос

Войдите, чтобы написать ответ

Войти через центр авторизации
Похожие вопросы