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

Question

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: [email protected]
      PGADMIN_DEFAULT_PASSWORD: ***
    ports:
      - "5050:80"

stackoverflow.com/questions/24718706/…

iLuvLogix
– iLuvLogix

2022-02-16 12:59:19 +00:00
Commented Feb 16, 2022 at 12:59 — iLuvLogix
– iLuvLogix, Commented Feb 16, 2022 at 12:59
@iLuvLogix your link does not talk about pgAdmin at all.

Sky
– Sky

2022-02-23 09:37:03 +00:00
Commented Feb 23, 2022 at 9:37 — Sky
– Sky, Commented Feb 23, 2022 at 9:37

Meraj al Maksud · Accepted Answer · 2022-12-12 03:38:16Z

3

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, 2022 at 3:38

Meraj al Maksud

1,6022 gold badges24 silver badges39 bronze badges

answered Dec 4, 2022 at 19:50

1endell

377 bronze badges

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

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related