Gets postgresql dump file from the server, restores local database and executes a sql file (i.e a script to reset user passwords for testing purposes)

update-dev-env.sh

#
# cron job runs at my-db-server with this configuration
# @daily pg_dump -Fc myRemoteDatabase > /var/lib/postgresql/backups/my-remote-database.dump
#
scp [email protected]:/var/lib/postgresql/backups/my-remote-database.dump ./temp.dump
pg_restore -h 127.0.0.1 -p 5432 -U postgres -c -d myLocalDatabase < ./temp.dump
psql -h 127.0.0.1 -p 5432 -U postgres -d myLocalDatabase -a -f ./reset-passwords.sql