Re: [HACKERS] Re: [GENERAL] How do I activate and change the postgresuser's password?

> 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
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026