scp login@host:path_to_dir_with/database_name_20160527.sql database_name_20160527.sqlpg_dump -U username dbname > dbexport.pgsql ----------- DOCKER ---------- # Dump (ROLES/USERS/GROUP) docker exec -i pg_container_name /bin/bash -c "PGPASSWORD=test pg_dumpall --host hostaddress --username test --globals-only" > /tmp/globals-dump.sql # Dump (DB/TABLES) docker exec -i pg_container_name /bin/bash -c "PGPASSWORD=test pg_dump --host hostaddress --username test --dbname database_name" > /tmp/db-dump.sql # Restore (ROLES/USERS/GROUP) docker exec -i pg_container_name /bin/bash -c "PGPASSWORD=test psql --username test" < /tmp/globals-dump.sql # Restore (DB/TABLES) docker exec -i pg_container_name /bin/bash -c "PGPASSWORD=test psql --username test --dbname database_name" < /tmp/db-dump.sql # or mount these files into your postgres docker container and import them with entry command.pg_dump dbname > outfilepg_dump -U your_username -d your_database_name > /path/to/sample_dump.sqlhttps://www.netguru.com/blog/how-to-dump-and-restore-postgresql-database