PG roles created for group members (ldap_user) are not being granted the PG role created for the group they are a member of (ldap_group)

[orlando-colamatteo]

We are seeing the sync happen between active directory and our pg cluster but the users are not granted the role representing the ldap group they are a member of.

State of Active Directory:

1. Group xyz_biz_analysts contains 1 member sally

What we see in pg cluster:

1. Role named xyz_biz_analysts is created and granted ldap_groups role
2. Role named sally is created and granted ldap_users role, but not the xyz_biz_analysts role

Desired:

1. Role named xyz_biz_analysts is created and granted ldap_groups role - OK
2. Role named sally is created and granted ldap_users role and is also granted xyz_biz_analysts role

[orlando-colamatteo]

@larskanis any insight you can provide here?

[MahammadAgayev]

Same issue here, Any updates?

[natigdba]

It is problem in me also. I try create by each group and members. Every time users are created before groups. In that case I can't map users to this group. Is there any solution?

1. I need groups are created before users ?
2. How to users map to groups in PostgreSQL ?

[NizamiOSS]

Having similar problem, any ideas ?