> Bruce Momjian wrote: > > > There is a todo item for the postgres user to have a password by default. > > > I'm not sure though how that would be done. Probably in initdb. (?) > > > > We could enabled it as part of initdb. Prompt them for it there, and > > assign it. Seems like there should be one on that account espeically. > > Also, allow a command line option to set the password for those who need > to automate things (like us RedHat people...). This is, I assume, for > the postgres user INSIDE the initial database structure, as opposed to > the postgres user on the OS. > > Since, under the RedHat installation, the initdb likely will happen > during initial system startup, having a prompt for a password at that > point is IMHO not good. Having a default password (in the initdb'd > pg_shadow) would be better. > > If this is about the OS userame 'postgres', ignore that. The RPM > installation already creates him, and makes it impossible to directly > log in as 'postgres' -- until root changes his password. No, this is about the pgsql-supplied postgres password. -- Bruce Momjian | http://www.op.net/~candle [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ************