Return False if Postgres role create or role update fails.

Fixes #8778.