Changing postgres User

From: Zac Warham <cazwarham(at)hotmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Changing postgres User
Date: 2024-10-14 20:11:49
Message-ID: ME3P282MB33285BBA32907655287F4AD9B7442@ME3P282MB3328.AUSP282.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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://github.com/PrairieLearn/PrairieLearn/pull/10713

Thanks,
Zac

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Durgamahesh Manne 2024-10-14 20:43:31 Re: How to Copy/Load 1 billions rows into a Partition Tables Fast
Previous Message Joe Conway 2024-10-14 19:08:58 Re: Help in dealing with OOM