postgresql_user: fix docstrings

Change documentation of "state" param to refer to user (role) state instead of
database state.

Change 2 function docstrings to reflect the code
Merge pull request #2543 from b6d/postgresql_user-docfix

postgresql_user: fix docstrings