postgresql_user resource not updating user
Documentation for using MD5 authentication for PG HA overrides
postgresql['sql_replication_user'] with the
gitlab_repmgr user. This causes the
gitlab::postgresql to create the user first, but without the superuser permissions it requires. The
postgresql_user resource only checks if the user exists.
The resource should be updated to compare permissions as well. If the user exists, but is different than what is expected, it should alter the user.
We should check if setting the
sql_replication_userto the repmgr user is the right way to go. As this now leaves us with a resource being managed by