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 1qkmPy-00GQUN-DJ for pgsql-admin@arkaria.postgresql.org; Mon, 25 Sep 2023 14:18:35 +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 1qkmPx-001tdM-5B for pgsql-admin@arkaria.postgresql.org; Mon, 25 Sep 2023 14:18:33 +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 1qkmPw-001tGF-05 for pgsql-admin@lists.postgresql.org; Mon, 25 Sep 2023 14:18:32 +0000 Received: from sonic316-54.consmr.mail.gq1.yahoo.com ([98.137.69.30]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qkmPq-007V0c-OW for pgsql-admin@lists.postgresql.org; Mon, 25 Sep 2023 14:18:31 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com.br; s=s2048; t=1695651502; bh=fKr71uerqGSs0cu0HIcN8g0Pm+/ixG4pyO0VLps4AzM=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=DyIgChiuPbVMS7HUtHUaNX3nQoH3ZluinCI3IukRh02egtxbnO/R6UqQDvfgTOrY4LDUipy3My8gW0V/iR53QFouxjVisWnIKDzk9Y5GiDud3lwFQ6kp8iFJtCB/kDvdBZElWOqWlVphqY+p6dFo+cnwU1dc1WTA3jB4bgQJLQUOO8fo3VQ7aj1zHZVxdykmJrv36GHanBWoFwP0SBunpeDJagwPvvWekm2akue6/EyFg3O2dogeqlqHyNPcqOTlp9FXYKnWnfmDQOmJlw9H+VNEhrTzHQDW1LHU0/fpY8HD1mxyvr0nvv6xORDn/zXTC61GuvU3YTaSKlmZWXoCKQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1695651502; bh=LXBUX9J0I9Q3lXFpm2+szwe/ezn4AYNRQm1DeiNLcpL=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=h5qIORSBCg1cw28Ow/if0A9fPsW9Jj6EV06fWPDijUTOZafnXfheuMcN3XKGklXCmL277DTy85EECF5R7eN/WNxIa9rM38PLW/JavPs5UXZz0LjpZtEdz3SsLagvnGvZs3q501G7cOORFUNj/l+LBvyp8xQN9UF1AYii0DjXCGnGTEifQN0GbIkOqWI33K/4hZUCkzsZa1jKQlUckizLAbTTnl0xpikPKPMNKZ/oNvRHmiZaXpfHPvCvFmwzSMvcnZbL8/0xOv+AEoPk1GDDoIkzUMKW+WcS3g5uVcDlvlR9zY9yhWO/SVVjOv2Ex6RcNJHzfAektd/T1PHk24skTw== X-YMail-OSG: kElbYF0VM1mx0CpFWx5rpIfDL_UBioOVB1HeC2CfyPCaAx8P5Qxlb6DLVglglCB xM.svqkGKjxn59uFLz3zAwQb8kHFeAD8C8pAqCJ5TVPgW6zYIkJRfNsb4wNZuZPZhmGeOdbgnQDo N6WqYkq9QZQ3ouJMUXJkyztFZmT6MTEkYuVD8ij_gy73J9HfFLYp1rAUfxsibeo53UzQYYmU3aTZ 2mcdl7ygVotg6wHu8mf5IIKB4AwXw9Wu1YJFb16ok_h.4fxd24N5H1fQ8szGA_O6yEiMzvzlT47p Aw_7iByBadnSm6rFIqCHvNXUeKKKKbTjkGjwcAQD6rN12vsPca.qlsUYgH0YA_WB22Y2Zo8wAKSk OnCykSmCgmSv10T8MqHDIrwMuPxLXkc757bpJhzaNC.3gTprVYQ07Xv7i.h1732p942ZCEo00oLH XUhvNWzLM2WfwqTdXx7TE2bHHoAT3xW7a4XfTeGaJbKE27gkGD1i45HBvyTDWEzvGDGFNJ8Vc_CS 2i3x0yUl0TmpU3tE.HW1boY2fvrZtSCI3CJrrb9Q6nPYV0qGlS7WkUNXXexiUuB71Y1p_YL5ePYi Qfsn68yXyH_f.MVN_lD0ScLOvanE5RtHQaORtaCGn6FC9GC1DvfZVdXww7G2fIdADmcAT0Zah1BQ iO02HxIWoWN_HS0n3WI9E8Sp8eDU97sAoz3kEnfVhC4UX4egJgnMEhJL0YkytsCWNBvcrOylEQ5z CzCI8bh5d2OxfSaXudiHVGxWrF1JBivLqdohj2jO.DpULq__5fhsWdyUDfReNLyRl4mC_m4UUit2 38udfSO2mV5F3a_wyij.AmTVDDudgVauWB_yebOnvScJNb2igEOpd0GP14suHT1m2Lz3loR67i1L eIkW5GPlN241EeR.akP.8Sfk4u62iiRKZeLEGT_jyseEnGcW7H.IDEThrODQB6pj_pb_VkXqJae4 93YiPLYdFoTpKFkjAmDNmjYqiwLizUKML6kKXU.cz3Lep7l87S6HQ6KCnavazDNVcGy_odS3Xtaf 3FqAxh0pSPHC24gMroIhRRpsVKGU0EZtkTAev7ak9N4COHFWtJDgZquAV9hf2X.El7lkAqw98G8C 4vL3L9e4zc7JaPY6M3Rg601mqCrS3ov2KVFvBJM3kiJSzJC2QoIoHY9Ht_zqngomO.NJsJe6KvFy CfgrOo2xZwF6QHm4RGzwgSD7_ncZ7nTAKYrO9I1d_Ipev8ZNwXlyNoGZ0UQxtLelWKHwYhWn9wq0 jqxvqjWqcbSYMOToGrrdjnBX_gZ5HK9GSyTJ93PU_6I01KqsyuivlfGzNyoV1b1h_ZFybNsb15yh bZN82uDa62r3qHvR_UEP7ggrGuhb9biKbGM7Vf3YzujL_5sYwT5cuEiEJ5_kpy26DT9ARgryJ1C5 BXpojTRkg3fHMJ_OMjjJY1we647Q8aHsUAPH_nu_o80oGsqP.Ce2tXpi1SNyFKTXtWNdQsIezzzN gQKF6PCJ47Xy4dWBf6G_Yl3HY5H029qeyANr6RbryCS9wOn6aO3TouKOcnZebK.pvL_AMEwzqVWo DdQoNu75AvBQ3.5vJKQ_QuvdatisdJeDYtFizvJIQluHE1REH9fja4MALoV5ZTc9ogyYppWA158g BJtGK_lgnJ4zyquz7.jCbxM5n.nCxL1A4GiaPvpt0eTPnRabchqR5RRQ13CR0PYWJZT27Z.4hyyn 3xY1aa52_1lf1zKDJFfqN751e87z7rd7Ivc.opAWTySz15qXO9lstfK8I3c9QoTT7HCBdm4Gsjb1 Taz3vPQh4uiJZBkn3ektkLgHMwEyhS2rQpXV2bumybVlJscM_wbTHAanATe04gq0ZrXkG6gnGV2L 69kkreDcI523zJ8AKdawhTNRQptLgis0NX0Cuh_SwxGasfJeXx7WMqXiCnZKIWRxkB1Rc5c5PNDu .PXh.q1_sFc34i10hs0WGrTBHPB1De6dDC3qYzJxg8cB0ee2csch.TmjOki85StyzHz0nZt3h4zZ 5kPL.DKQCIUiuo.woeuoi1tpcPKhP2TedjqzyN5J72IeO_MYXGC_W1mJnTFgomy59d7lzhkB3bTJ iFQH1nbAyPTQ_1anmwrZuRBq8sBZIL8ZVCXVpZkWwux3JFGXlpETctd.x4z2nB4DDi_Qtfb84V4G PWC0zhoKTKJSh9C9ecbR6SVfngc_EelOC0frf0xPzXe6Pmj4XDYfkzf68ig_c3K3F9mVuhFho5DD vV1Rg2QoT8HHXTA7SpBzo7MwzDWsg1UDwYxLznCMtfVZ3MOjEjCg.2ogGXNsphsP3Ysadg6Q- X-Sonic-MF: X-Sonic-ID: 9ae81d11-d765-48bf-b3bb-fcdcc34e7ed5 Received: from sonic.gate.mail.ne1.yahoo.com by sonic316.consmr.mail.gq1.yahoo.com with HTTP; Mon, 25 Sep 2023 14:18:22 +0000 Date: Mon, 25 Sep 2023 14:18:17 +0000 (UTC) From: Marcus Vinicius Castro To: "pgsql-admin@lists.postgresql.org" , mu88 Message-ID: <1530634129.5400509.1695651497538@mail.yahoo.com> In-Reply-To: <28c7d917-d9fe-4d8b-aee1-5764190d9e5e@posteo.eu> References: <28c7d917-d9fe-4d8b-aee1-5764190d9e5e@posteo.eu> Subject: Re: Seed pgAdmin roles with Active Directory groups when using Docker MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_5400508_708960894.1695651497536" X-Mailer: WebService/1.1.21797 YMailNorrin Content-Length: 5785 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_5400508_708960894.1695651497536 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable My friend, I didn't use this feature yet. but, I believe that you can writ= e PowerShell script to help with that. I used PowerShell to set up my containers. Best regards. Marcus Henriques Desenvolvedor =E2=80=93 Spassu Tecnologia Tel: + 55 (21) 98065-7785 =C2=A0 =C2=A0 =20 Em segunda-feira, 25 de setembro de 2023 =C3=A0s 08:02:32 BRT, mu88 escreveu: =20 =20 Hi,=20 =20 I want to setup a pgAdmin instance for our team using the Docker deployment= . As our organization uses Active Directory, I'd like to assign the pgAdmin= User role to a specific AD group when starting the pgAdmin Docker containe= r.=20 =20 Within the docs I already found the option to use pgAdmin with LDAP, so hop= efully accessing our AD should work.=20 =20 What I didn't find: is it possible to assign a pgAdmin role to an AD group = or only to AD users? And if yes, can this automatically happen on Docker co= ntainer start (e. g. by using an environment variable or a config file simi= lar to servers.json)?=20 =20 Or put in other words: is it possible that it looks like this after contain= er start only by configuration without any manual interaction? =20 =20 Best regards!=20 =20 PS: you find this question here as well: https://dba.stackexchange.com/ques= tions/331385/seed-pgadmin-roles-with-active-directory-groups-when-using-doc= ker=20 =20 ------=_Part_5400508_708960894.1695651497536 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
My friend, I didn= 't use this feature yet. but, I believe that you can write PowerShell scrip= t to help with that.

I used PowerShell to set up my containers.

Be= st regards.


Marcus Henriques

<= /span>

Desenvolvedor =E2=80=93 Spassu Tecn= ologia

Tel: + 55 (21) 98065-7785


 

 

=


=20
=20
Em segunda-feira, 25 de setembro de 2023 =C3=A0s 08:02:= 32 BRT, mu88 <mu88+dev@posteo.eu> escreveu:


=20 =20 =20
Hi,

I want to = setup a pgAdmin instance for our team using the Docker deployment. As our o= rganization uses Active Directory, I'd like to assign the pgAdmin User role= to a specific AD group when starting the pgAdmin Docker container.

Within the= docs I already found the option to use pgAdmin with LDAP, so hopefully acc= essing our AD should work.

What I did= n't find: is it possible to assign a pgAdmin role to an AD group or only to= AD users? And if yes, can this automatically happen on Docker container st= art (e. g. by using an environment variable or a config file similar to ser= vers.json)?

Or put in = other words: is it possible that it looks like this after container start o= nly by configuration without any manual interaction?

Best regar= ds!

PS: you fi= nd this question here as well: https://dba.stackexchange.com/questions/3313= 85/seed-pgadmin-roles-with-active-directory-groups-when-using-docker
------=_Part_5400508_708960894.1695651497536--