Minor edit to the pg_hba.conf to only allow the postgres user full perms via localhost