Achilleas, for this setup to work are changes to postgresql.conf and pg_hba.conf needed? I am trying to implement this for AWS rds Aurora where these files are not accessible.
Those files are needed in any case if you work with postgresql. Unfortunately no experience with Aurora. He have been building from source for ages.