Populate rover postgres DB in Docker dev env from RDS dev DB - HearstCorp/rover-wiki GitHub Wiki

First get a DB dump:

PGPASSWORD=<dev DB password> pg_dump -h dev-rover-db-primary.dev.mediaos.hearst.io -U mediaos mediaos | gzip > dev_dump.sql.gz

then log into the container

docker exec -it rover-web bash

and delete and recreate its DB

export PGPASSWORD=password
dropdb -h rover-postgres -U postgres postgres
createdb -h rover-postgres -U postgres postgres
createuser -h rover-postgres -U postgres mediaos

and slurp the DB dump

zcat dev_dump.sql.gz | PGPASSWORD=password psql -h rover-postgres postgres postgres

finally reset the admin@localhost password

./manage.py changepassword admin@localhost