Do we need to create hd*********' as both user and role?
Since a PG role and a PG user are the same thing under the hood, the later simply meaning the role can login, then no. Though maybe you mean a OS user since you are dealing with operating system commands here...?
Maybe show your work so we aren't left guessing what you are trying to do.