For the ansible novice, they requirement to populate the module and version manually when it's not described in the documented labs could make things difficult to understand.
the community.postgresql module should not have been deprecated from the requirements.txt and should be reinstated.