Sign inSign up

codefornl/pg-copy

By codefornl

•Updated almost 7 years ago

Docker image for copying databases with a cronjob

Image
0

234

codefornl/pg-copy repository overview

⁠pg-copy

Docker image for copying databases with a cronjob

⁠Example:

Set up a postgresql docker instance

docker network create consul_nw
docker run -e POSTGRES_PASSWORD=postgres --name=consul_db -p 5432:5432 --net=consul_nw -d postgres:10-alpine
docker exec -it consul_db createdb -U postgres consul

Setup a consul docker instance

docker run -p 3000:3000 --name=consul_web -e DATABASE_HOST=consul_db --net=consul_nw -d codefornl/consul
docker exec -it consul_web bin/rake db:migrate

Create a copy of the database

docker build -t clowder/pg-copy:1.0 .
docker run --name=consul_copy \
  -e POSTGRES_HOST=consul_db \
  -e SOURCE_DATABASE=consul_development \
  -e TARGET_DATABASE=consul_test \
  --net=consul_nw clowder/pg-copy:1.0

Tag summary

Content type

Image

Digest

Size

5.3 MB

Last updated

almost 7 years ago

docker pull codefornl/pg-copy