while trying to make multiple connects with different role names to a single database over VPN i faced a password error issue when trying to connect a send user
It seems I had to change this line in pg_hba.conf and it worked:
`# IPv4 external connections thru VPN
#TYPE DATABASE USER ADDRESS METHOD host all all <ip> trust ` <=(from the earlier scram-sha-256)
is this the way and is this correct from a security point of view ?