Skip to content

Instantly share code, notes, and snippets.

@grammy-jiang

grammy-jiang/postgresql_dump_and_restore.md

Last active September 17, 2022 01:21
Show Gist options
  • Save grammy-jiang/71063d451aa5ebbed69834122245a848 to your computer and use it in GitHub Desktop.
Save grammy-jiang/71063d451aa5ebbed69834122245a848 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL dump and restore within Docker
Raw
postgresql_dump_and_restore.md

PostgreSQL dump and restore within Docker

Dump a database in PostgreSQL with pg_dump inside a docker container

docker run \
  -it --rm -v <volume>:/tmp/pg_dump postgres:latest \
  pg_dump \
  --host=<host> --port=<port> \
  --username=<username> --password \
  --dbname=<database> -f /tmp/pg_dump/<database>.sql

Restore a database backuped by pg_dump with psql inside a docker container to another PostgreSQL instance inside another docker container

docker run \
  -it --rm --network=<network> -v <volume>:/tmp/pg_dump postgres:latest \
  psql \
  --host=<host> --port=<port> \
  --username=<username> --password \
  -dbname=<database> -f /tmp/pg_dump/<database>.sql

Reference

Docker

PostgreSQL

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment