Skip to content

Instantly share code, notes, and snippets.

@maslick

maslick/pg_dump

Created January 7, 2016 07:50
Show Gist options
  • Save maslick/d1d4e6c2acce99857ea6 to your computer and use it in GitHub Desktop.
Save maslick/d1d4e6c2acce99857ea6 to your computer and use it in GitHub Desktop.
Download ZIP
Docker container for pg_dump
Raw
pg_dump
FROM postgres
ENTRYPOINT ["/usr/bin/pg_dump"]
@maslick
Copy link
Author

maslick commented Jan 7, 2016

  1. docker build -t pg_dump - < Dockerfile
  2. docker run -it -e PGPASSWORD={POSTGRES_PWD} --link {POSTGRES_CONTAINER}:db pg_dump -h db -U {POSTGRES_USER} > dump.sql

@maslick
Copy link
Author

maslick commented Jan 11, 2016

docker exec -i <container_id> bash -c 'cat > /path/to/container/file' < /path/to/host/file/
dropdb keycloak -U keycloak
createdb keycloak -U keycloak
psql -U keycloak -d keycloak -f dump_kc.sql

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