From: Zac Warham <cazwarham@hotmail.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>,
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: Changing postgres User
Thread-Topic: Changing postgres User
Thread-Index: AQHbHnSPvczEV2/ssUq6PpI2wNnPwbKGyEOAgAAF4+8=
Date: Mon, 14 Oct 2024 22:09:59 +0000
Message-ID:
 <ME3P282MB3328FDD3AD68DFD183B1E9A4B7442@ME3P282MB3328.AUSP282.PROD.OUTLOOK.COM>
References:
 <ME3P282MB33285BBA32907655287F4AD9B7442@ME3P282MB3328.AUSP282.PROD.OUTLOOK.COM>
 <685640e7-4533-4483-acfc-d8dc60de5515@aklaver.com>
In-Reply-To: <685640e7-4533-4483-acfc-d8dc60de5515@aklaver.com>
Accept-Language: en-AU, en-US
Content-Language: en-AU
msip_labels:
x-ms-exchange-messagesentrepresentingtype: 1
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: ME3P282MB3328:EE_|SY6P282MB4086:EE_
x-ms-office365-filtering-correlation-id: 4f7c2f2e-2d8f-452c-2db8-08dcec9cf1a5
x-microsoft-antispam:
 BCL:0;ARA:14566002|12050799009|8062599003|461199028|8060799006|15030799003|7092599003|19110799003|15080799006|9400799024|4302099013|3412199025|440099028|102099032|10035399004|1602099012;
x-microsoft-antispam-message-info:
 =?us-ascii?Q?PxV7r6BJEQkidkYykmi54r9sCQduMlSWIwFaVU08SfEj24HVt7JrKOWmfG7K?=
 =?us-ascii?Q?J3QCGqv52T3ewedDWRFCjsx/cinlAncQNq5bMtEWWhiTfXZwUe4COZRi/+3s?=
 =?us-ascii?Q?d+N0AWAdMqkXnhCR9N4ai33u345gfUPOMeUNGhU9SfA70I/aE3i7DnhgXXxE?=
 =?us-ascii?Q?SYE0nmrhXhnr4jaKNQpOpQ9I0/MAdrBNWdehIXL/ARme9Lygi8YkE3nSt/u8?=
 =?us-ascii?Q?qGcaRdUOhPn/K7oUjAlX+j5AyFc7KzuzIXNSWKQ5URLQNnPMBigxcrKvowhm?=
 =?us-ascii?Q?YHjH/a1QAQRUn557wtTdslMyJanKvAlddEbDlif5/5Am7rItV4+yex/S+lkF?=
 =?us-ascii?Q?UfJwTXTsraQOcnAF+yqx75nlxxwPOrbG4tABIaTbi0d7rfCzmBiIfZEzJTjz?=
 =?us-ascii?Q?ZBmLYWJg2CRvpesgzRwwMfDY2SwNGaqwu75EzJGSV5GXPCTi3qCWrL2nHx+7?=
 =?us-ascii?Q?+wY+qeSspSn084G8mg4f61jxYyW7Gd5WevZ7adJMF60vhif0a1LjBw6KHqms?=
 =?us-ascii?Q?+sbnJcRD1ob0tR3WaRY0yE8xeQxjvZPEL7/0SbCym4bCgc3r0S9sKWZhTEsf?=
 =?us-ascii?Q?i1xrgrVSQw+062KrPu82XFeCLKZIB37UvdcEUxTBuNcD9gmBft2/92xS9yLm?=
 =?us-ascii?Q?jsjaXMMgEeILqaxUcWQWPrKY9ArXDokOfrrK9Z6+zYkJTgqObnOyy7Eu+14n?=
 =?us-ascii?Q?v9Q5Dd6cWHCf+oNsZu2rdJFQucSmjtiTgYCdBxKi+9pLb5dPX3m3KFZ1+ECK?=
 =?us-ascii?Q?MOF6BNWY3Q+C9BjM45QgMKtGPyGycopGkbcnjsKphjRP9U5/W1v4t0yIYI80?=
 =?us-ascii?Q?gMBA7L/0ibv3FfVGyZHNO4LcaWmR47vKmz8wFWiD7w6bc7FctwadiQWMC7FI?=
 =?us-ascii?Q?niwSS6DEl0v9D/bcutOFTkoyRwDuDZekkyBY0UQiXXRgcVXqbH0zLSJT3ESY?=
 =?us-ascii?Q?PfGNwOnUWH5iERgaTKH4YpaEWLEtslAYvGymkj0vw+s=3D?=
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?us-ascii?Q?B/DYYYezEcpxG5fCWMUrjV0sshxGKdLHgUFWneUspWq7MNPWoneFzyGi1jWL?=
 =?us-ascii?Q?HvvVBAYzBReXdH2ZTQ9bPwLDuHwAKmf9at4Rj5jMSbCYMf0zZygR7RwynUwz?=
 =?us-ascii?Q?jaTPDE3meBu6Cw4BGcgBT7S2rBcuimBTjqXbQKWxsg86zpGJ6stQLdrYMoWs?=
 =?us-ascii?Q?oAvoKY+x2E6jlK7aoirIU10UlTROYNFrKr3ydJMPBnevNiYlKB0PTuwtVvof?=
 =?us-ascii?Q?JST23WRjh1cb+TbPhjzz/HQMn4oxoiKg8214lOyXPO+DuGb8TtZA3DEpjaZO?=
 =?us-ascii?Q?wCKIJUF+ZqnbF65qwDc6zzc38RK/iijtFyWie77SFOiUG5gOi01hW0ku9qJa?=
 =?us-ascii?Q?Tj85hwCU52rr/QtPKxitMn7Ybr3AmPdQVOLXyAorW7UCEJm86heFdPB2Sj5I?=
 =?us-ascii?Q?CxrMRts4w1w3KCFiSN5y1+IyUwLC+Mtj1mzC7DXhCPpLhjzs+2vBWLjkvq15?=
 =?us-ascii?Q?D7VCCZWFnHiSZ1lwQHx52hA//XCQ+k5OT2zcy6jXp4rGnBtGJJcrbVechk5/?=
 =?us-ascii?Q?M2YppWP+LV9e6cvdjZOKKY1531Ryg6vRMT5pf7X4q3te4L8qiNx96i11Ko+R?=
 =?us-ascii?Q?WIdn8ekWo7aoKC7S6ZQrTKhrTBH1nwiD5MCXfnifwmCeptz0hxFUbdsObGJB?=
 =?us-ascii?Q?7TIW7W3l2NmvtYAPONJcJ72UJ3p6JluMOKqRML+hWIPXtPfA6Mr20teIkxyf?=
 =?us-ascii?Q?GIPDXTQBAr0uuEahCJ6i9EP7Q13OKmB8ZyFGucI9yFkZMB5gDbXA18TRULm9?=
 =?us-ascii?Q?MO0Q+U2TWCoDc6Bo0DxiLlUooPT3lJgsBV5TWOQo+D6jYqtTeWDSG+jopr7c?=
 =?us-ascii?Q?vlr4gCFtMxjgXAaDK8ui9koN7ysYPagarhdYpPqIke1t9m1CbgrNRXw5AVxN?=
 =?us-ascii?Q?kSRKHHtNYRvEK4clCuJkDbb7AwPSMaPFVzUKEWTfjtsGSDKs5DLpmLOMOqn+?=
 =?us-ascii?Q?kWE60E/sU4nApv+RSjw7APMXiDjWaxsSYW/B01FJD8hb6qfL1DDiyfx3aXCo?=
 =?us-ascii?Q?lSz+c00bURlHUqKPbZ0uFy5yCtl3VKWlMRzz5v/frvwFhAo1LFpAqRwJfJJH?=
 =?us-ascii?Q?B2PLBhEqgwJ4kMMrnhgYJk2aio1VgZmzCmJtWHkNwPP4SvnNdrzstReeczxo?=
 =?us-ascii?Q?7W1nm591LEq0eZBMDSA7jLH9erUgl8HASwSu+grVaZP0YxCale7Ghnaq+8io?=
 =?us-ascii?Q?EOfvOZP+SWUDflQuvCwl2gF7PPzUgz7kHhubKM/+l9n6qrLaRACm3zN+Tx0?=
 =?us-ascii?Q?=3D?=
Content-Type: multipart/alternative;
	boundary="_000_ME3P282MB3328FDD3AD68DFD183B1E9A4B7442ME3P282MB3328AUSP_"
MIME-Version: 1.0
X-OriginatorOrg: sct-15-20-7719-20-msonline-outlook-722bc.templateTenant
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: ME3P282MB3328.AUSP282.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000
X-MS-Exchange-CrossTenant-Network-Message-Id: 4f7c2f2e-2d8f-452c-2db8-08dcec9cf1a5
X-MS-Exchange-CrossTenant-originalarrivaltime: 14 Oct 2024 22:09:59.2874
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SY6P282MB4086
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/ME3P282MB3328FDD3AD68DFD183B1E9A4B7442%40ME3P282MB3328.AUSP282.PROD.OUTLOOK.COM>
Precedence: bulk

--_000_ME3P282MB3328FDD3AD68DFD183B1E9A4B7442ME3P282MB3328AUSP_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi Adrian,

Thank you for the link to the documentation however it is the UID and GID o=
f 1001:1001 that is required, not the username which I believe this is inte=
nded for? Is there a similar option for UID and GID? Apologies if my origin=
al question was not clear in this manner.

Zac
________________________________
From: Adrian Klaver <adrian.klaver@aklaver.com>
Sent: Monday, 14 October 2024 2:46 PM
To: Zac Warham <cazwarham@hotmail.com>; pgsql-general@lists.postgresql.org =
<pgsql-general@lists.postgresql.org>
Subject: Re: Changing postgres User

On 10/14/24 13:11, Zac Warham wrote:
> Hi,
>
> We are trying to setup a postgresql Docker container alongside pgadmin
> and caddy for use in the PrairieLearn student testing software. Our main
> set back is that the PrairieLearn production environment user runs as
> user 1001:1001 and as such we have had to rename the postgres user
> within Linux to 1001 and alter the credentials management significantly.

Why?

Per:

https://aus01.safelinks.protection.outlook.com/?url=3Dhttps%3A%2F%2Fwww.pos=
tgresql.org%2Fdocs%2Fcurrent%2Fapp-initdb.html&data=3D05%7C02%7C%7C545e2e27=
90694e5ec81a08dcec99ba83%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C63864=
5392223140652%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiL=
CJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=3DLNVisA1Cm%2BK8twl9PxP18k=
l8zcDsgo77ySEvtIuXfZI%3D&reserved=3D0<https://www.postgresql.org/docs/curre=
nt/app-initdb.html>

You can have the initdb create the cluster as any user:

"-U username
--username=3Dusername

     Sets the user name of the bootstrap superuser. This defaults to the
name of the operating-system user running initdb.
"

>
> We are currently brainstorming some better ways but if anyone has any
> suggestions on easier ways to make these changes then we would
> appreciate them. The code is open source and can be viewed here -
> https://aus01.safelinks.protection.outlook.com/?url=3Dhttps%3A%2F%2Fgithu=
b.com%2FPrairieLearn%2FPrairieLearn%2Fpull%2F10713&data=3D05%7C02%7C%7C545e=
2e2790694e5ec81a08dcec99ba83%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C6=
38645392223163417%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luM=
zIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=3D3Rj3%2BG4PYJIEzymBaK=
dl%2BbkooYroK7HzH3M2eHM2f8Y%3D&reserved=3D0<https://github.com/PrairieLearn=
/PrairieLearn/pull/10713>
> <https://aus01.safelinks.protection.outlook.com/?url=3Dhttps%3A%2F%2Fgith=
ub.com%2FPrairieLearn%2FPrairieLearn%2Fpull%2F10713&data=3D05%7C02%7C%7C545=
e2e2790694e5ec81a08dcec99ba83%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C=
638645392223177366%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2lu=
MzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=3Dgy3LgO2pe7FhiL28lfL=
fNBO8Y1%2B2BDunSR%2FDsFE8wyU%3D&reserved=3D0<https://github.com/PrairieLear=
n/PrairieLearn/pull/10713>>
>
> Thanks,
> Zac

--
Adrian Klaver
adrian.klaver@aklaver.com


--_000_ME3P282MB3328FDD3AD68DFD183B1E9A4B7442ME3P282MB3328AUSP_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hi Adrian,</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thank you for the link to the documentation however it is the UID and GID o=
f 1001:1001 that is required, not the username which I believe this is inte=
nded for? Is there a similar option for UID and GID? Apologies if my origin=
al question was not clear in this
 manner.</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Zac</div>
<div id=3D"appendonsend"></div>
<hr style=3D"display:inline-block;width:98%" tabindex=3D"-1">
<div id=3D"divRplyFwdMsg" dir=3D"ltr"><font face=3D"Calibri, sans-serif" st=
yle=3D"font-size:11pt" color=3D"#000000"><b>From:</b> Adrian Klaver &lt;adr=
ian.klaver@aklaver.com&gt;<br>
<b>Sent:</b> Monday, 14 October 2024 2:46 PM<br>
<b>To:</b> Zac Warham &lt;cazwarham@hotmail.com&gt;; pgsql-general@lists.po=
stgresql.org &lt;pgsql-general@lists.postgresql.org&gt;<br>
<b>Subject:</b> Re: Changing postgres User</font>
<div>&nbsp;</div>
</div>
<div class=3D"BodyFragment"><font size=3D"2"><span style=3D"font-size:11pt;=
">
<div class=3D"PlainText">On 10/14/24 13:11, Zac Warham wrote:<br>
&gt; Hi,<br>
&gt; <br>
&gt; We are trying to setup a postgresql Docker container alongside pgadmin=
 <br>
&gt; and caddy for use in the PrairieLearn student testing software. Our ma=
in <br>
&gt; set back is that the PrairieLearn production environment user runs as =
<br>
&gt; user 1001:1001 and as such we have had to rename the postgres user <br=
>
&gt; within Linux to 1001 and alter the credentials management significantl=
y.<br>
<br>
Why?<br>
<br>
Per:<br>
<br>
<a href=3D"https://www.postgresql.org/docs/current/app-initdb.html">https:/=
/aus01.safelinks.protection.outlook.com/?url=3Dhttps%3A%2F%2Fwww.postgresql=
.org%2Fdocs%2Fcurrent%2Fapp-initdb.html&amp;data=3D05%7C02%7C%7C545e2e27906=
94e5ec81a08dcec99ba83%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C63864539=
2223140652%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJB=
TiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&amp;sdata=3DLNVisA1Cm%2BK8twl9PxP18=
kl8zcDsgo77ySEvtIuXfZI%3D&amp;reserved=3D0</a><br>
<br>
You can have the initdb create the cluster as any user:<br>
<br>
&quot;-U username<br>
--username=3Dusername<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp; Sets the user name of the bootstrap superuser. Thi=
s defaults to the <br>
name of the operating-system user running initdb.<br>
&quot;<br>
<br>
&gt; <br>
&gt; We are currently brainstorming some better ways but if anyone has any =
<br>
&gt; suggestions on easier ways to make these changes then we would <br>
&gt; appreciate them. The code is open source and can be viewed here - <br>
&gt; <a href=3D"https://github.com/PrairieLearn/PrairieLearn/pull/10713">ht=
tps://aus01.safelinks.protection.outlook.com/?url=3Dhttps%3A%2F%2Fgithub.co=
m%2FPrairieLearn%2FPrairieLearn%2Fpull%2F10713&amp;data=3D05%7C02%7C%7C545e=
2e2790694e5ec81a08dcec99ba83%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C6=
38645392223163417%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luM=
zIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&amp;sdata=3D3Rj3%2BG4PYJIEzy=
mBaKdl%2BbkooYroK7HzH3M2eHM2f8Y%3D&amp;reserved=3D0</a>
<br>
&gt; &lt;<a href=3D"https://github.com/PrairieLearn/PrairieLearn/pull/10713=
">https://aus01.safelinks.protection.outlook.com/?url=3Dhttps%3A%2F%2Fgithu=
b.com%2FPrairieLearn%2FPrairieLearn%2Fpull%2F10713&amp;data=3D05%7C02%7C%7C=
545e2e2790694e5ec81a08dcec99ba83%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0=
%7C638645392223177366%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV=
2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&amp;sdata=3Dgy3LgO2pe7Fh=
iL28lfLfNBO8Y1%2B2BDunSR%2FDsFE8wyU%3D&amp;reserved=3D0</a>&gt;<br>
&gt; <br>
&gt; Thanks,<br>
&gt; Zac<br>
<br>
-- <br>
Adrian Klaver<br>
adrian.klaver@aklaver.com<br>
<br>
</div>
</span></font></div>
</body>
</html>

--_000_ME3P282MB3328FDD3AD68DFD183B1E9A4B7442ME3P282MB3328AUSP_--