From: Zac Warham <cazwarham@hotmail.com>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Changing postgres User
Thread-Topic: Changing postgres User
Thread-Index: AQHbHnSPvczEV2/ssUq6PpI2wNnPwQ==
Date: Mon, 14 Oct 2024 20:11:49 +0000
Message-ID:
 <ME3P282MB33285BBA32907655287F4AD9B7442@ME3P282MB3328.AUSP282.PROD.OUTLOOK.COM>
Accept-Language: en-AU, en-US
Content-Language: en-AU
x-ms-exchange-messagesentrepresentingtype: 1
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: ME3P282MB3328:EE_|SY0P282MB5301:EE_
x-ms-office365-filtering-correlation-id: 9612d591-c32b-43aa-bbff-08dcec8c6fe0
x-microsoft-antispam:
 BCL:0;ARA:14566002|8062599003|9400799024|461199028|12050799009|19110799003|14030799003|8060799006|7092599003|15080799006|440099028|3412199025|4302099013|10035399004|102099032|1602099012;
x-microsoft-antispam-message-info:
	=?us-ascii?Q?7RMLCiuThF6JU6QKNXe8hmGtO1pY3BsJCfujajdF6R7uHkKp/nz3egda2r3D?=
 =?us-ascii?Q?2QFkWN3PrBB3C7+z4UNW/Od52bMnIF1LUtmXKUPu3wwnDIwVOr6HrF0gN0ac?=
 =?us-ascii?Q?Pq21v2C2OrMCWPvWhxuLgI+f3C3RHgdnh0O+2hmPAtQuphnX7iVkbSPRuVsf?=
 =?us-ascii?Q?/30fsgB4zezBQ3yMyBCwH7WUZi4mJHaOsMAo3NbOrIwuPPd7VQX0IZdI0Zmv?=
 =?us-ascii?Q?MPPDVJioPxHG13ywAvxHFFhBhzaOU4YvatzQjbfROcGxk2FmcK3k/QG7dEsM?=
 =?us-ascii?Q?5R2XvK7B+v7hGJMF6dHdRqQWvd3F1ErkORgWGsYCKw/k0Nd28Sv4y79qgKSV?=
 =?us-ascii?Q?RMQMuzXzjjJiXU3sBRTPHwlLSxkLEO6n9Ays1Vj0bME/mSMxd3Mh78XZ6bOy?=
 =?us-ascii?Q?a0q3Ez7zm5TUINSaFRQKFrGLiooJAlwQqDzuBwejOuKZydE6nh3C5zxEWvNN?=
 =?us-ascii?Q?EZyr1WbwuEGbWXuHVnppz3zNTt1kdFxbsNTh4hFpF/5s12Xrix5ZctcofwCU?=
 =?us-ascii?Q?qfGIsbkG6fDhmdpzgZ+j3/gQq3/0Goe7esm8oRyJFZfsQ7YTWL7ZEiKJoGOV?=
 =?us-ascii?Q?vuUb7s/lI3aIN9odXpt+0ro9pK+xgOPyI5go0UxbhJkH6in7NRRMgrcwAybH?=
 =?us-ascii?Q?HtkTvIAeg2+piHtxaVWnT5HMJlnN1V/RaUHUj3B+OIIppyvP+OAzKJJm0E5J?=
 =?us-ascii?Q?M9ZqdjMKETdjtHPLO1mAX2uAMBT+M3TKWV4A6/lzxcgZBiRGVx/rCWVJkQOt?=
 =?us-ascii?Q?T+VLuEQNdL8roeQhuKHlrcKbUxHV8zeCqZeKvFUg17JkzIq+MKJeOl49Rnhv?=
 =?us-ascii?Q?qPBtt5zASyO2MkWF1aeQrLIzd45ddKeNgIdMfc5gDnqguVvB4S7lU7IVvoTD?=
 =?us-ascii?Q?PJq0KZbCAgbYdwBmzEA4ttYPFejAumh3YZAYv1y7iNif6vHTefYk4B0mA3Jc?=
 =?us-ascii?Q?lghAtxLnUerkwo+rr1rmbA=3D=3D?=
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?us-ascii?Q?nUUtd3sxdrxMOszOhtUyRPYfsAtSDaqYpf9hi/VjdMqMZFhfrmtGRlb5z6kH?=
 =?us-ascii?Q?JWILJ8RzZRXsN+WW0gdF+s6nEQNHoVIXZTPB1F5Og1YuH40LBNqGQO18ww2c?=
 =?us-ascii?Q?eM78Ucj2k9XjUGOD9Y/2Ubb+C51yX3Qp7VXPZiwP5JVBCk91eT0abSRyODeR?=
 =?us-ascii?Q?DWP8wZvO2v/YmHdO9OS6IzsIiMuRNAdjGaO7S9W3jiKxbDmlTD96kNiqw0QC?=
 =?us-ascii?Q?CyY52im1P73bciUil8pbvM4Mg8Cvw400PyIoLHuZQMWKbKa2GEc9RQJFoj3S?=
 =?us-ascii?Q?6V4wokGfMpfTOJGRWdXXJOkG1QTDuRSXEmDpgB+8K8/nJuTDmlxTly0UuVIT?=
 =?us-ascii?Q?pc2TzpJevgrDlhzY0jIGflqAHFOMx4PiBZOBiOoeC+/is0e1UwD4gud7d17R?=
 =?us-ascii?Q?cm5tCNMxQTdJvvSJwrjz4ubSrT3nTTVSixST/ccQc5AB6b/9Ge7XluZOpPAs?=
 =?us-ascii?Q?c7kk1YTm1i6YKk+rPRy4ck66LdY3axPJ2G9z/7XjqhVdWkfwAmW9d8r6NmpW?=
 =?us-ascii?Q?ktgydxILoy7l63hPLZcw6l5kkKHJkv8FOcD/YITinDh96Wt31cONdlevyrzx?=
 =?us-ascii?Q?uNtUrvRlXpZMTlcmzMapmSvbOlXDAFXeH2O86k2Mt2HDJgmk1ztDcR3AiUFz?=
 =?us-ascii?Q?cOJ+j6yGpecA7RS5Saa9RcDbc/1OcXPcsLt4ip6JZMpYmxUA8gQLYmUqfHy4?=
 =?us-ascii?Q?FBNjWhfNcH+9IGek/Bz/+mTtJNHFpu2czpVKzd3tAD5jpaXEg0f1TyF6YpFY?=
 =?us-ascii?Q?dF+b2dqxLgXdXakLbco04TN1ziDTDls2Smgdfgx/p1gU4xJefWTsSl9q8Rg7?=
 =?us-ascii?Q?ywLU1yBMAZRs/QUkghrliOUkuYqWofCRmVyXWEI7rSvFMzrUsgr0GGEPf1HM?=
 =?us-ascii?Q?KEVzl50D0Y66Qgv6A5GgjrZDc4nk+lT8djuKSWd6Ey1tcw6k8AP1nhqh/UkU?=
 =?us-ascii?Q?8+qLJSRSwWQnJJX0MQPtemzM5OiPY9ZNXoVKhTi5CylGfpMu807XAiu7JmTe?=
 =?us-ascii?Q?jJHq7cRmLXs1A5aSHptPDk7Evry2Gzar/qJSrRxgEOMDjQDTr1WHNhfAT9Cv?=
 =?us-ascii?Q?YGLw2ZLAwoAsS5xEbz10GQv0YUtpuyj0U1Te4P6BsTWbaAXY3FdnhuScpOi0?=
 =?us-ascii?Q?aq0ruQkxGc76gHI9YQVInm3LC34ib3Ed3mO7Lk4m1muWNpRSbdb4yneUP1sC?=
 =?us-ascii?Q?iDO8u46SPOHfSu0FkSnIqNdbnMMHrEjv1Ov8fcqB8z/Nm9ZoxWmi+f60b/ir?=
 =?us-ascii?Q?T9wLQvLhhuEy1pxTa8fF?=
Content-Type: multipart/alternative;
	boundary="_000_ME3P282MB33285BBA32907655287F4AD9B7442ME3P282MB3328AUSP_"
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: 9612d591-c32b-43aa-bbff-08dcec8c6fe0
X-MS-Exchange-CrossTenant-originalarrivaltime: 14 Oct 2024 20:11:49.5769
 (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: SY0P282MB5301
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/ME3P282MB33285BBA32907655287F4AD9B7442%40ME3P282MB3328.AUSP282.PROD.OUTLOOK.COM>
Precedence: bulk

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

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 ba=
ck is that the PrairieLearn production environment user runs as user 1001:1=
001 and as such we have had to rename the postgres user within Linux to 100=
1 and alter the credentials management significantly.

We are currently brainstorming some better ways but if anyone has any sugge=
stions on easier ways to make these changes then we would appreciate them. =
The code is open source and can be viewed here - https://github.com/Prairie=
Learn/PrairieLearn/pull/10713

Thanks,
Zac

--_000_ME3P282MB33285BBA32907655287F4AD9B7442ME3P282MB3328AUSP_
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"=
>
</head>
<body>
<div dir=3D"auto">Hi,</div>
<div dir=3D"auto"><br>
</div>
<div dir=3D"auto">We are trying to setup a postgresql Docker container alon=
gside pgadmin and caddy for use in the PrairieLearn student testing softwar=
e. Our main set back is that the PrairieLearn production environment user r=
uns 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.&nbsp;</div>
<div dir=3D"auto"><br>
</div>
<div dir=3D"auto">We are currently brainstorming some better ways but if an=
yone 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 -
<a href=3D"https://github.com/PrairieLearn/PrairieLearn/pull/10713">https:/=
/github.com/PrairieLearn/PrairieLearn/pull/10713</a></div>
<div dir=3D"auto"><br>
</div>
<div dir=3D"auto">Thanks,&nbsp;</div>
<div dir=3D"auto">Zac</div>
</body>
</html>

--_000_ME3P282MB33285BBA32907655287F4AD9B7442ME3P282MB3328AUSP_--