$ pg_dumpall > pg_all.sql

$ psql -U lsmith -f pg_all.sql postgres