MIME-Version: 1.0
References: 
 <CANzqJaBD0vqs6=ovHOjUF4SV80pBx6A-1kZ8mwcryJq2bjFH2g@mail.gmail.com>
 <2DFE4EC0-7374-4D5E-BC05-49530F7015A0@126.com>
In-Reply-To: <2DFE4EC0-7374-4D5E-BC05-49530F7015A0@126.com>
From: kaido vaikla <kaido.vaikla@gmail.com>
Date: Wed, 17 Sep 2025 11:27:29 +0300
Message-ID: 
 <CA+427g_wA-i+DaN0h4nP=MxrfJUezC4OKkPmJgauyghi+L4DtQ@mail.gmail.com>
Subject: Re: Allow connections by IP address?
To: =?UTF-8?B?5p2O5piO?= <liming185216@126.com>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>,
 pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000916dc9063efb02cd"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2B427g_wA-i%2BDaN0h4nP%3DMxrfJUezC4OKkPmJgauyghi%2BL4DtQ%40mail.gmail.com>
Precedence: bulk

--000000000000916dc9063efb02cd
Content-Type: text/plain; charset="UTF-8"

Maybe this way.
Create a roles like
gr_4
gr_5
gr_4_5

grant roles by needs to users and define roles in pg_hba.conf (USER: +gr_4).


br
Kaido

--000000000000916dc9063efb02cd
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:monospace,monospace"><br></div></div><br><div class=3D"gmail_quote=
 gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr"><div class=3D=
"gmail_default" style=3D"font-family:monospace,monospace">Maybe this way.<b=
r>Create a roles like=C2=A0<br>gr_4<br>gr_5<br>gr_4_5<br><br>grant roles by=
 needs to users and define roles in pg_hba.conf (USER: +gr_4).<br><br><br>b=
r<br>Kaido</div><br></div><blockquote class=3D"gmail_quote" style=3D"margin=
:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"=
><div dir=3D"auto"><div><blockquote type=3D"cite"><div dir=3D"ltr">
</div></blockquote></div></div></blockquote></div></div>

--000000000000916dc9063efb02cd--