Re: Suggestion : support for environment variable in initdb to set the superuser password

2025-05-30 Thread Reda Agaoua
Le mer. 28 mai 2025, 13:26, Peter Eisentraut a écrit : > On 27.05.25 11:43, Reda Agaoua wrote: > "Insecure, but it's ok because it's not > used very often" > This isn't what I meant, but I guess it's the same so maybe I didn't think this through as much as I thought I had ! Still, is the concer

Re: Suggestion : support for environment variable in initdb to set the superuser password

2025-05-28 Thread Peter Eisentraut
On 27.05.25 11:43, Reda Agaoua wrote: I do believe it can be useful in a variety of settings, but I'm not sure whether this is secure. Specifically, the documentation advises against using PGPASSWORD for connecting to postgres : "Use of this environment variable is not recommended for security

Suggestion : support for environment variable in initdb to set the superuser password

2025-05-27 Thread Reda Agaoua
Hi, The initdb command currently supports prompting for the superuser password using --pwprompt or reading it from a file using --pwfile. I’m wondering if it might also make sense to allow specifying the password via an environment variable. I do believe it can be useful in a variety of settings,