sudo -i -u postgres
psql

create database <dbname>;

create user <rolename> with login password 'qwerty';

grant all privileges on database <dbname> to <rolename>;

=== PSQL ===
psql -U username -d dbname < filename.sql

-- For Postgres versions 9.0 or earlier
psql -U username -d dbname -1 -f filename.sql

=== PG_RESTORE ===
pg_restore -U username -d dbname -1 filename.dump