Create postgresql role and database from shell

gistfile1.txt

# create password - note the md5 is the prefix and the value is user + password
$ U=testpg; P=testpg; echo -n md5; echo -n $P$U | md5sum | cut -d' ' -f1
$ md54bb01023735acf990f528fe961df8140
# connect to pg
$ psql
postgres=# CREATE ROLE testpg NOSUPERUSER NOCREATEDB NOCREATEROLE NOINHERIT LOGIN PASSWORD 'md54bb01023735acf990f528fe961df8140';
postgres=# CREATE DATABASE testpgdb OWNER testpg;
^D
# at this point you can connect to the database `testpgdb` such so
$ psql -U testpg -d testpgdb -h YOURHOST -W