Manually create Postgres password hash

For some reason you have to pass the password hash if you want to create a role in postgres. To calculate the hash use the following snippet:

echo -n "md5"; echo -n "${PG_PASSWORD}${PG_USERNAME}" | md5sum | awk '{print $1}'