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 1v9M2i-00GVrU-Mk for pgsql-admin@arkaria.postgresql.org; Thu, 16 Oct 2025 11:21:12 +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 1v9M2g-00C84T-P9 for pgsql-admin@arkaria.postgresql.org; Thu, 16 Oct 2025 11:21:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v9M2g-00C83v-B6 for pgsql-admin@lists.postgresql.org; Thu, 16 Oct 2025 11:21:09 +0000 Received: from mail-qk1-x729.google.com ([2607:f8b0:4864:20::729]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v9M2c-002VvE-2M for pgsql-admin@lists.postgresql.org; Thu, 16 Oct 2025 11:21:09 +0000 Received: by mail-qk1-x729.google.com with SMTP id af79cd13be357-88fca7a60cfso80481085a.2 for ; Thu, 16 Oct 2025 04:21:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1760613664; x=1761218464; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=b1DK/P29TUdkLYYljKSQAmm/gU8PHt+oWgfsld+Iewo=; b=EXsqTRyKcZmLlMcbI5oOwo0VSRovxN9QA6drMuZt9HgJW4WIlAAIsQiVnKQUwC5o6V bwA5gFZeZZaq7eBFVTDk8V1hV1PdPGjiMkvkdL1+q+OnH8SGwjQ3pzhgNbIZAqQd+RXE V/Oy3XedxJsvWI4yrYKxOL5GAIbUTqfZqjWSuZMkFWjBaV4c8f9W7woh0Ue7Oga+Lx3t ug9SHUFX7wPP9DKWhbsFcLo5uNjLqVX2VRdH8hPUPNroMrLK5mFGX3qvKO9JEA07bwNj MaeRT8OdG8dMH2HA9eopVxgOivceRXdsv+jsU9fGi69AEjOFl8JPpg9SADPn7ofElyWg y+VQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760613664; x=1761218464; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=b1DK/P29TUdkLYYljKSQAmm/gU8PHt+oWgfsld+Iewo=; b=jXq+g4iM5rOn6Lk2pwW+CJj8a48pcdI8ZuPo1GwGdFWFLopWxxWWOIIXNO7hgsJHD5 o70zsD+liyDxClUXWb7DN8b/UvCLNSymOIeRjOJdOyUOXWv1MZAzV6ioaE2B/C/x0GW1 k2A6YZrT8ZdU2z0RqYyn7tMfN0exlImPjtxHZVlk9O86JGfUSfpymA2hE0JDkknYh9dh UFiluA/eBfD6jFAx8p8cbLi0STkk56qEyMUyo+R1hzVgAbpwajHQ+Ap4ZDl+LXfzK5+P 7grk/8LHYy5R6BqvzBB+PmBPiLSQRPEYt3CAxwtwwu0Jyc2r8QrJdE/ikli45y9LZAx0 ct9w== X-Forwarded-Encrypted: i=1; AJvYcCWgmILv+5ZrLkzxn4bGfyCgvTooa+Vza/4CbmPQ+qTJN+9mX7MLEmW9VCwfaYphzZ9/e93M1+fmhnp26g==@lists.postgresql.org X-Gm-Message-State: AOJu0Yx5WXw1yRcNQCrdosjbJc9d0jp0a2NinHycEjbQhx/R3jaycPx+ mlOzlyR5ySzG8EhwLFerpoySTlz0vZKy6DEtaB3wvnXJcLehFNbWoK0beH9gw4hqgu9eUtclHEV ivhpQ/DupvhQQrp6HU7i9QTAQl8oyAec9Qw== X-Gm-Gg: ASbGncs0mleM8eM13us3ppkD18rTJwFvmB7s/wx2Gve1SmTcVgStmHgyOMllZYBeGmV t+iYM8b4vKgH3rKGlyWqgtAhOIb8ng+c60stlcmr4OOn1nQV/1EbNKH8Tt/L+uBGJ2qyAsMZqhA tEn9nVZkrjqpat9yKNslQuWm7nsavFHyHaQS/LO2Iq7g+gB0UKS0WUUgngfALNRFfgxuNVlkkIV zxpgctaG6M4PF+BHU4U7MHuRdnczOZJ57GWFHK/MK6FHGkKcOuub7hvaXq2iylzINJSqk32y2uL HnAjd/YWDMmMoE/g5A== X-Google-Smtp-Source: AGHT+IFSNNA4GiBEUflEPpKVFKAMQ+5U39J6tli0H1YSnWZPrlCMYbCqQ5el+umCfhI+Lxsz1uKOMu7/gy2/2wAxzo8= X-Received: by 2002:a05:622a:148d:b0:4e7:2635:c31c with SMTP id d75a77b69052e-4e72635c3bcmr202764801cf.83.1760613664245; Thu, 16 Oct 2025 04:21:04 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: John Tensingh Date: Thu, 16 Oct 2025 07:20:51 -0400 X-Gm-Features: AS18NWA0UyWpbFEGHIZrnU17sDjrb2VB07180SLklsDYTKcjA53B4e7cyQEyyMc Message-ID: Subject: Re: Linux - possibe Postgres USERID/Password Management To: Patolla Bernd Cc: "Subramanian,Ramachandran" , "pgsql-admin@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000000b5e05064144d03b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000b5e05064144d03b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable One could user RADIUS authentication as well. We have used it successfully. Here is the documentation: https://www.postgresql.org/docs/current/auth-radius.html Regards John T. On Thu, Oct 16, 2025 at 7:07=E2=80=AFAM Patolla Bernd wrote: > Hi Ram, > > You can use any AD or ldap server for authentication. Document is here: > https://www.postgresql.org/docs/current/auth-ldap.html > > BR > Bernd > > -- > Bernd Patolla > Dipl. Inform. Univ. > Senior IT Consultant > > > *In&Out AG* IT Consulting & Engineering > Stockeristrasse 2, CH-6343 Risch > > > Phone: +41 44 485 60 60 | Mobile: +41 79 831 19 61 > *bernd.patolla@inout.ch * | *www.inout.ch > * > > > *Wir machen Ihnen das Leben einfacher. Ganzheitliche und > l=C3=B6sungsorientierte Beratung. Von der Analyse bis zur erfolgreichen > Einf=C3=BChrung.* > > > *Von: *Subramanian,Ramachandran < > ramachandran.subramanian@alte-leipziger.de> > *Datum: *Donnerstag, 16. Oktober 2025 um 12:51 > *An: *pgsql-admin@lists.postgresql.org > *Betreff: *Linux - possibe Postgres USERID/Password Management > > Hello, > > > > > > With the base Postgres Product, Is there a way to let the Operating Syste= m > deal with authenticating a user=E2=80=98s connection and remove the burde= n of > creating, communicating and freqently changing the password for each > role/user? > > > > 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 > management. I am grateful for any pointers. > > > > > > Ram > > > > Freundliche Gr=C3=BC=C3=9Fe > > *i. A. Ramachandran Subramanian* > > Zentralbereich Informationstechnologie > > Alte Leipziger Lebensversicherung a. G. > > Hallesche Krankenversicherung a. G. > > ______________________ > > 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 > > Alte Leipziger Lebensversicherung a. G., Alte Leipziger-Platz 1, 61440 > Oberursel > > > Vors. des Aufsichtsrats: Dr. Walter Botermann =C2=B7 Vorstand: Christoph = Bohn > (Vors.), Dr. J=C3=BCrgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Joch= en > Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek > > Sitz Oberursel (Taunus) =C2=B7 Rechtsform VVaG =C2=B7 Amtsgericht Bad Hom= burg v. d. > H. HRB 1583 =C2=B7 USt.-IdNr. DE 114106814 > > Hallesche Krankenversicherung a. G., L=C3=B6ffelstra=C3=9Fe 34-38, 70597 = Stuttgart > > > Vors. des Aufsichtsrats: Dr. Walter Botermann =C2=B7 Vorstand: Christoph = Bohn > (Vors.), Dr. J=C3=BCrgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Joch= en > Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek > > Sitz Stuttgart =C2=B7 Rechtsform VVaG =C2=B7 Amtsgericht Stuttgart HRB 26= 86 =C2=B7 > USt.-IdNr. DE 147802285 > > Beitr=C3=A4ge zu privaten Kranken- und Pflegekrankenversicherungen unterl= iegen > nicht der Versicherungsteuer (=C2=A7 4 (1) Nr. 5 b VersStG) =C2=B7 > Versicherungsleistungen sowie Ums=C3=A4tze aus > Versicherungsvertreter-/Maklert=C3=A4tigkeiten sind umsatzsteuerfrei > > Pflichtangaben der ALH Gruppe > gem=C3=A4=C3=9F =C2=A7 35a GmbHG bzw. =C2=A7 80 AktG > --0000000000000b5e05064144d03b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
One could user RADIUS authentication as well. We have use= d it successfully.
Here is the documentation:
<= div dir=3D"auto">
Regards
John T.


On Thu, Oct 16, 2025 at 7:07=E2=80=AFAM Patolla Bernd <bernd.patolla@inout.ch> wrote:
Hi Ram,

You can use any AD or ldap server for authentication. Document is here: https://www.postgresql.org/docs/current/auth-ldap.html

BR=C2=A0
Bernd

--

Bernd = Patolla
Dipl. = Inform. Univ.
Senior= IT Consultant

=C2= =A0

In&Out AG=C2=A0IT Consulting & Engineering
Stockeristrasse 2, CH-6343 Risch

Phone: +41 44 485 60 60 | Mobile: +41 79 831 19 61
bernd.patolla@inout.ch=C2=A0| www.inout.ch

Wir machen Ihnen das Leben einfacher= .
Ganzheitliche und l=C3=B6sungsorientierte Beratung. Von der Analyse bis zur= erfolgreichen Einf=C3=BChrung.

=C2= =A0

Hello,

=C2=A0

=C2=A0

With the base P= ostgres Product, Is there a way to let the Operating System deal with authe= nticating a user=E2=80=98s connection and remove the burden of creating, co= mmunicating and freqently changing the password for each role/user?

=C2=A0

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

=C2=A0

In short, we th= e DBAs do not want to be responsible for password management. =C2=A0=C2=A0I= am grateful for any pointers.

=C2=A0

=C2=A0

Ram

=C2=A0


Freundliche Gr=C3=BC=C3=9F= e


i. A. Ramachandran Subr= amanian

Zentralbereich Informationstechnologie

Alte Leipziger Lebensversi= cherung a. G.

Hallesche Krankenversicher= ung a. G.

______________________

ALH Gruppe
Alte Leipziger-Platz 1, 61440 Ober= ursel
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

Alte Leipziger Lebensversic= herung a. G., Alte Leipziger-Platz= 1, 61440 Oberursel

Vors. des Aufsichtsrats: Dr= . Walter Botermann =C2=B7 Vorstand: Christoph Bohn (Vors.), Dr. J=C3=BCrgen= Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexander M= ayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek

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


Hallesche Krankenversicheru= ng a. G., L=C3=B6ffelstra=C3= =9Fe 34-38, 70597 Stuttgart

Vors. des Aufsichtsrats: Dr= . Walter Botermann =C2=B7 Vorstand: Christoph Bohn (Vors.), Dr. J=C3=BCrgen= Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexander M= ayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek

Sitz Stuttgart =C2=B7 Recht= sform VVaG =C2=B7 Amtsgericht Stuttgart HRB 2686 =C2=B7 USt.-IdNr. DE 14780= 2285

Beitr=C3=A4ge zu privaten K= ranken- und Pflegekrankenversicherungen unterliegen nicht der Versicherungs= teuer (=C2=A7 4 (1) Nr. 5 b VersStG) =C2=B7 Versicherungsleistungen sowie U= ms=C3=A4tze aus Versicherungsvertreter-/Maklert=C3=A4tigkeiten sind umsatzsteuerfrei


Pflichtangaben=C2=A0der ALH Gruppe gem=C3=A4=C3=9F =C2=A7 3= 5a GmbHG bzw. =C2=A7 80 AktG

--0000000000000b5e05064144d03b--