Как импортировать БД Postgres в контейнер docker?

Question

[xRA1Nx]

Добрый день! Подскажите полажуйста, как импортировать дамп БД Postgres в контенер Postgres?

Я пытаюсь сделать это так:

Dockerfile:

FROM postgres
COPY postgres.sql /docker-entrypoint-initdb.d/

yml

services:
  db:
    build: ./DB
    volumes:
      - ./data/db:/var/lib/postgresql/data
    environment:
      - POSTGRES_DB=postgres
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=postgres
  web:
    build: .
    command: python manage.py runserver 0.0.0.0:8000
    volumes:
      - .:/code
    ports:
      - "8000:8000"
    environment:
      - POSTGRES_NAME=postgres
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=postgres
    depends_on:
      - db

Структура проекта

Comments

[xRA1Nx]

vilinyh

Добрый день. Спасибо за подсказку и желание помочь!!!
При первичном старте папки data/db не существует (она создается в процессе).

Ошибка при старте следующая:

gamenews_proj-db-1 | initdb: warning: enabling "trust" authentication for local connections
gamenews_proj-db-1 | You can change this by editing pg_hba.conf or using the option -A, or
gamenews_proj-db-1 | --auth-local and --auth-host, the next time you run initdb.
gamenews_proj-db-1 | waiting for server to start....2022-08-18 11:11:20.935 UTC [49] LOG: starting PostgreSQL 14.5 (Debian 14.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
gamenews_proj-db-1 | 2022-08-18 11:11:20.938 UTC [49] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
gamenews_proj-db-1 | 2022-08-18 11:11:20.961 UTC [50] LOG: database system was shut down at 2022-08-18 11:11:18 UTC
gamenews_proj-db-1 | 2022-08-18 11:11:20.982 UTC [49] LOG: database system is ready to accept connections
gamenews_proj-db-1 | done
gamenews_proj-db-1 | server started
gamenews_proj-db-1 | CREATE DATABASE
gamenews_proj-db-1 |
gamenews_proj-db-1 |
gamenews_proj-db-1 | /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/postgres.sql
gamenews_proj-db-1 | The input is a PostgreSQL custom-format dump.
gamenews_proj-db-1 | Use the pg_restore command-line client to restore this dump to a database.
gamenews_proj-db-1 |
gamenews_proj-db-1 exited with code 1