How to restore postgres dump through pgadmin docker container (dockerized postgres)

Question

Dear stackoverflowers,

I use docker-compose to run the dockerized postgresql server and dockerized pgadmin4 webserver. When i try to restore a dump via the web interface it shows me an empty folder with the path "/" for source location of the dump.

Now my question, is it in general possible to restore a dump via dockerized pgadmin and if, what path from which container (postgres or pgadmin) do i have to mount as volume to provide the dump to be restored?

    version: '3.8'

services:
  db:
    container_name: pg_container
    image: postgres:12.10
    restart: always
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: ***
      POSTGRES_DB: postgres
    ports:
      - "5432:5432"
  pgadmin:
    container_name: pgadmin4_container
    image: dpage/pgadmin4
    restart: always
    environment:
      PGADMIN_DEFAULT_EMAIL: admin@admin.com
      PGADMIN_DEFAULT_PASSWORD: ***
    ports:
      - "5050:80"

With kind regards starguy

https://stackoverflow.com/questions/24718706/backup-restore-a-dockerized-postgresql-database — iLuvLogix, Feb 16 '22 at 12:59

score 1 · Answer 1 · edited Dec 12 '22 at 03:38

1

I'm in the same situation as you are. In the web pgadmin, you have an option to upload a .sql file just by clicking at the ... button.

pgadmin4 upload image

edited Dec 12 '22 at 03:38

Meraj al Maksud

1,528
2
22
36

answered Dec 04 '22 at 19:50

1endell

15
6

How to restore postgres dump through pgadmin docker container (dockerized postgres)

1 Answers1