run command under user postgres

to backup

$pg_dumpall > db.sql

to restore

$psql -f db.sql template1