Skip to content

Instantly share code, notes, and snippets.

@chandrajob365

chandrajob365/restore

Forked from jgillman/restore.sh
Created January 23, 2018 06:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save chandrajob365/25bd5b33f6a5348a94d3c5842dcb320f to your computer and use it in GitHub Desktop.
Save chandrajob365/25bd5b33f6a5348a94d3c5842dcb320f to your computer and use it in GitHub Desktop.
Download ZIP
pg_restore a local db dump into Docker
Raw
restore
# Assumes the database container is named 'db'
DOCKER_DB_NAME="$(docker-compose ps -q db)"
DB_HOSTNAME=db
DB_USER=postgres
LOCAL_DUMP_PATH="path/to/local.dump"
docker-compose up -d db
docker exec -i "${DOCKER_DB_NAME}" pg_restore -C --clean --no-acl --no-owner -U "${DB_USER}" -d "${DB_HOSTNAME}" < "${LOCAL_DUMP_PATH}"
docker-compose stop db
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment