Access sql dump inside docker container django postgres

Question

I'm using Django with Postgres database so I've created separate docker containers for Django and Postgres, now I want to share the dump file with my team but I'm unable to access the dump file, please let me know how can I access the dump file and after accessing it how can we import it using the container?

docker-compose.yml

version: "3.8"
   
services:
  pgdb:
    image: "postgres"
    restart: always
    volumes:
      - postgres_data:/var/lib/postgresql/data/
    ports:
      - "5432:5432"

location inside db docker container

Possible duplicate of stackoverflow.com/questions/24718706/… — iklinac
– iklinac, Commented Dec 23, 2021 at 13:48

iklinac · Accepted Answer · 2021-12-23 13:34:03Z

1

You can access it using docker cp utility

docker cp [OPTIONS] CONTAINER:SRC_PATH DEST_PATH|-

But rather than doing that you can directly pipe output of pg_dump

docker exec -t container pg_dump ... > dump.sql

and import

cat dump.sql | docker exec -i container psql ...

edited Dec 23, 2021 at 13:34

answered Dec 23, 2021 at 13:15

iklinac

15.8k5 gold badges32 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Zain Khan Over a year ago

how would I import that dump inside the same container on another system?

Collectives™ on Stack Overflow

Access sql dump inside docker container django postgres

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related