get remote postgree database

gistfile1.txt

#!/bin/bash

[email protected]
REMOTE_DB_NAME=db_production
REMOTE_DB_USER=db_user
REMOTE_DB_PASS=db_pass
LOCAL_DB=db_local

echo $REMOTE_DB_PASS | pbcopy

ssh $REMOTE_HOST "pg_dump --host localhost --port 5432 --username $REMOTE_DB_USER --password $REMOTE_DB_NAME" > prod_database.sql
dropdb $LOCAL_DB
createdb -T template1 $LOCAL_DB
psql -d $LOCAL_DB -f prod_database.sql
rm -rf prod_database.sql