Skip to content

Instantly share code, notes, and snippets.

@maslick

maslick/pg_dump

Created January 7, 2016 07:50
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save maslick/d1d4e6c2acce99857ea6 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
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

maslick commented Jan 7, 2016

Copy link
Copy Markdown
Author
  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

maslick commented Jan 11, 2016

Copy link
Copy Markdown
Author

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