Tag: pg_restore

[code language=”language="ruby”] /Applications/Postgres.app/Contents/Versions/9.6/bin/pg_dump -Fc -v -h 100.12.12.110 -p 5432 -U db_admin -d mysite_prod_v1 > mysite_oct.dump [/code]

[code language=”ruby”] /Applications/Postgres.app/Contents/Versions/9.6/bin/pg_restore –verbose –clean –no-acl –no-owner -h localhost -U postgres -d my_db ~/Downloads/staging.dump [/code]