How to backup/restore postgres database?

[Raruto]

Currently the readme only explains how to log in as a postgres user, but how is it possible to dump the data? (ie. how to export a dump.sql file on host machine?)

This is what I found on stackoverflow:

backup psql:

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

restore psql:

cat dump.sql | docker exec -i g3w-suite-docker-postgis-1 psql -U postgres

but I think it still needs a few minor tweaks to work: backup-restore-a-dockerized-postgresql-database

[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