__postgres_role: state param optional, fix password param

I was having an issue where the password parameter wasn't working for __postgres_role. I also made it so the state parameter is optional.