PostgreSQL

#Connect to DB That Requires SSL

# shell
psql -h hostaname -U user "dbname=something_production sslmode=require"

#Dump and Restore All Databases

# shell
# dump
pg_dumpall -c > dump.sql

# restore
psql -f dump.sql postgres

-c tells pg_dumpall to include statements to drop existing databases before loading and recreating them.