Multiple connections over VPN password fail error

From: Sanjay Minni <sanjay(dot)minni(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Multiple connections over VPN password fail error
Date: 2024-02-09 07:41:01
Message-ID: CAMpxBon7iZ+4v0FtbY48ME2yOXX-g1ewwGP2YaTnp4Ah_G3Psg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All

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 ?

regards
Sanjay Minni

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Gustafsson 2024-02-09 07:56:54 Re: Multiple connections over VPN password fail error
Previous Message Adrian Klaver 2024-02-09 00:31:13 Re: Migrate schemas