pg_dump -U user -d db_name -h 127.0.0.1 > dump.sql

psql -U username -d dbname < filename.sql