Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v9LaX-00GJb9-Ow for pgsql-admin@arkaria.postgresql.org; Thu, 16 Oct 2025 10:52:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v9LZY-00BfOp-Ib for pgsql-admin@arkaria.postgresql.org; Thu, 16 Oct 2025 10:51:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v9LZX-00BfOf-VV for pgsql-admin@lists.postgresql.org; Thu, 16 Oct 2025 10:51:03 +0000 Received: from mx2.alte-leipziger.de ([91.217.145.232]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v9LZU-0024sE-0e for pgsql-admin@lists.postgresql.org; Thu, 16 Oct 2025 10:51:01 +0000 X-CSE-ConnectionGUID: 8Ig1EWaSQUmPihoLXF/qvw== X-CSE-MsgGUID: 6GQ+OYcYTimrGsbueOv7jg== From: "Subramanian,Ramachandran" To: "pgsql-admin@lists.postgresql.org" Subject: Linux - possibe Postgres USERID/Password Management Thread-Topic: Linux - possibe Postgres USERID/Password Management Thread-Index: Adw+ibaWtttDzwAXTkugq7KEuFd6kQ== Date: Thu, 16 Oct 2025 10:50:50 +0000 Message-ID: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-tmase-matchedrid: +gTBWF+Z0RMRXbylt4bi97bW4WOZNAUnj5XD/cFEQwaQ+UeH24Dz4Lhu upHpXEmLU2VRnkEujdpjybcuQlsAB7ipA0mFNtPDyGyaQXOvRx4pihtGF1HQYaINgcEzNI9jZFU 1OAyYdMNZjJ97HVOvx69eyMYvo72fqd+JFy8QGHUWd/c/Vdyl4FYSmaIHbAjb4gefAI4RchDFaz jVQn9PbzIs3LEAaA7XDPCABlvGN8DnD7CWM3QMUmE7EKfp+9g6Keq7SLQVPz7+1lSrNijX38JnG WdwJ9vKboqu2vEiEaNz0zwfL2Dj8WQVn6iCbqgAO9AbTF0WkMLlfU7eJmtONi3W2Nmwisj+FZpP lpzh62UcDP1wsc7/aJmvVkpP7YC+Il4qK2g0f3ltJ6O4f4yLXaCfX1AcCU7Mfs/V3Fa58F6Xuoz idp2s3fDvD8IZilbYg63Rs0pPGEHMfMvKqGVEWTs+rxnh7qV6c2m8ZFmiw7Ol8ia45E7uP7AUbd dgkNAa1qKNO5aOvPS7My2vrl/AHWW83XlKlkAaSwwcGKLTYEc= x-tm-as-user-approved-sender: No x-tm-as-user-blocked-sender: No x-tmase-result: 10--23.758100-8.000000 x-tm-snts-smtp: 3E3F5C193B661B20E8AAFB3EA108DE695C74668F98659BCD5DA3EDDDDA6BC1F72000:8 x-alsentwithgood: false Content-Type: multipart/alternative; boundary="_000_e113025a98c04bab864d47ac7a0db215alteleipzigerde_" MIME-Version: 1.0 X-GBS-PROC: EHofQTKKgmLjDkEgqCvtNdzPfxzE9m9tI5jo/hQQfquOnznPOvHFK0H7+sbG9NM+ X-GBS-PROCJOB: =?utf-8?Q?n/Qgu/RdRmRkeFVWb1eFmqvYS9rOx7Z3URJbyumMHz/GrNCHLTGbqpYEOviw?= =?utf-8?Q?JNpHpulqJoU02KDAaUJxkKfiQxl0OE9Xee6pVQIo06GcqgdSbJK/pxcJ+v3d?= =?utf-8?Q?6iiHPtlyBCnnax0jUDGBVW2exBgYUcBIZrCcUfMW2Ybt3gXy6/8=3D?= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_e113025a98c04bab864d47ac7a0db215alteleipzigerde_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, With the base Postgres Product, Is there a way to let the Operating Syste= m deal with authenticating a user=27s connection and remove the burden of= creating, communicating and freqently changing the password for each rol= e/user=3F If not possible, please suggest some reliable and easy to use extensions/= 3rd party tools to achieve the same. In short, we the DBAs do not want to be responsible for password manageme= nt. I am grateful for any pointers. Ram Freundliche Gr=FC=DFe i. A. Ramachandran Subramanian Zentralbereich Informationstechnologie Alte Leipziger Lebensversicherung a.G. Hallesche Krankenversicherung a.G. Alte Leipziger Lebensversicherung a.G., Alte Leipziger-Platz 1, 61440 Obe= rursel Vors. des Aufsichtsrats: Dr. Walter Botermann =B7 Vorstand: Christoph Boh= n (Vors.), Dr. J=FCrgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Joche= n Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcs= ek Sitz Oberursel (Taunus) =B7 Rechtsform VVaG =B7 Amtsgericht Bad Homburg v= . d. H. HRB 1583 =B7 USt.-IdNr. DE 114106814 =20 Hallesche Krankenversicherung a.G., L=F6ffelstra=DFe 34-38, 70597 Stuttg= art Vors. des Aufsichtsrats: Dr. Walter Botermann =B7 Vorstand: Christoph Boh= n (Vors.), Dr. J=FCrgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Joche= n Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek Sitz Stuttgart =B7 Rechtsform VVaG =B7 Amtsgericht Stuttgart HRB 2686 = =B7 USt.-IdNr. DE 147802285 Beitr=E4ge zu privaten Kranken- und Pflegekrankenversicherungen unterlieg= en nicht der Versicherungsteuer (=A7 4 Nr. 5 VersStG) =B7 Versicherungsle= istungen sowie Ums=E4tze aus Versicherungsvertreter-/Maklert=E4tigkeiten = sind umsatzsteuerfrei =20 =20 Die Pflichtangaben der ALH Gruppe gem=E4=DF =A7 35a GmbHG bzw. =A7 80 Akt= G finden Sie hier: https://www.alte-leipziger.de/impressum=20 ______________________ ALH Gruppe Alte Leipziger-Platz 1, 61440 Oberursel Tel.: +49 (6171) 66-4882 Fax: +49 (6171) 66-800-4882 E-Mail: ramachandran.subramanian@alte-leipziger.de www.alte-leipziger.de www.hallesche.de --_000_e113025a98c04bab864d47ac7a0db215alteleipzigerde_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello,

 

 

With the base Postgres Product, Is there = a way to let the Operating System deal with authenticating a user‘s= connection and remove the burden of creating, communicating and freqentl= y changing the password for each role/user=3F

 

If not possible, please suggest some reli= able and easy to use extensions/3rd party tools to achieve the same.

 

In short, we the DBAs do not want to be r= esponsible for password management.   I am grateful for any poi= nters.

 

 

Ram

 


Freundliche Gr=FC=DFe


i. A. Ramachandran Subrama= nian =20

Zentralbereich Informationst= echnologie

=20

Alte Leipziger Lebensversicherung a. G.<= /SPAN>

Hallesche Krankenversicherung a. G.

=20

______________________

ALH Gruppe
Alte Leipziger-Platz 1, 614= 40 Oberursel
Tel: +49 (6171) 66-4882
Fax: +49 (6171) 66-800-4882E-Mail: ramachandran.subramanian@alte-leipziger.de
www.alte-leipziger.de
www.hallesche.de

Alte Leipziger Lebensversich= erung a. G., Alte Leipziger-Platz 1, 61440 Oberursel

Vors. des Aufsichtsra= ts: Dr. Walter Botermann =B7 Vorstand: Christoph Bohn (Vors.), Dr. J=FCrg= en Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexand= er Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek

Sitz Oberursel (Taunus) =B7 = Rechtsform VVaG =B7 Amtsgericht Bad Homburg v. d. H. HRB 1583 =B7 USt.-Id= Nr. DE 114106814


Hallesche Krankenversicherun= g a. G., L=F6ffelstra=DFe 34-38, 70597 Stuttgart

Vors. des Aufsichtsrats: Dr.= Walter Botermann =B7 Vorstand: Christoph Bohn (Vors.), Dr. J=FCrgen Bier= baum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexander Maye= r, Christian Pape, Wiltrud Pekarek, Udo Wilcsek

Sitz Stuttgart =B7 Rechtsfor= m VVaG =B7 Amtsgericht Stuttgart HRB 2686 =B7 USt.-IdNr. DE 147802285

Beitr=E4ge zu privaten Krank= en- und Pflegekrankenversicherungen unterliegen nicht der Versicherungste= uer (=A7 4 (1) Nr. 5 b VersStG) =B7 Versicherungsleistungen sowie Ums=E4t= ze aus Versicherungsvertreter-/Maklert=E4tigkeiten sind umsatzsteuerfrei<= /SPAN>


= Pflichtangaben der A= LH Gruppe gem=E4=DF =A7 35a GmbHG bzw. =A7 80 AktG --_000_e113025a98c04bab864d47ac7a0db215alteleipzigerde_--