emailrhoads/pg_dump_import.md

Last active November 12, 2020 19:06

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/emailrhoads/bcc4f756d072b2bfc6e1a566fa17168d.js"></script>
Save emailrhoads/bcc4f756d072b2bfc6e1a566fa17168d to your computer and use it in GitHub Desktop.

[Import PG Dump] Create new pg ddump import #gemini #postgres

Raw

Create new database

dropdb gemini_development
createdb gemini_development

pg_restore -j $(nproc) -c --no-owner --if-exists -d gemini_development <path to dump>

bundle exec rake db:drop db:create
pg_restore -h localhost -U railsuser -j $(nproc) -c --no-owner --if-exists -d gemini_development <path to dump>

PGPASSWORD=$LUNA_DB_PASSWORD pg_restore -h $LUNA_DB_HOST -U $LUNA_DB_USER -j 2 -c --no-owner --if-exists -d $LUNA_DB tmp/libra_prod_07102020.sql