postgres role changes

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.