How to backup/restore postgres database? about g3w-suite-docker

[Raruto]

As per #54 (comment):

docker exec -t g3w-suite-docker-postgis-1 pg_dumpall -c -U postgres > dump.sql

# dump.sql
# pg_dumpall: could not connect to database "template1": FATAL:  Peer authentication failed for user "postgres"

adding -h localhost:

docker exec -t g3w-suite-docker-postgis-1 pg_dumpall -c -U postgres -h localhost > dump.sql 

# dump.sql created as empty file (command line interface hangs indefinitely)

[Raruto]

In this case the shared volume of postgis service has the following mapping:

g3w-suite-docker/docker-compose-dev.yml

Line 19 in 09750b9

- g3wsuite-pg-data:/var/lib/postgresql

As per docker documentation on how backup restore or migrate data volumes, you can find that folder under in this location:

# Linux 

/var/lib/docker/volumes/

# Windows (WSL 2)

\\wsl$\docker-desktop-data\version-pack-data\community\docker\volumes

More info:

• https://docs.docker.com/storage/volumes/#create-and-manage-volumes