Gary Horton <Gary(dot)Horton(at)Sun(dot)COM> writes:
> We're migrating from 7.3.4 to 8.1.0, and I'm seeing different behavior
> with the createuser command. What we are wanting is to streamline our
> product installs, to require minimal user interaction, so we basically
> embed the password like this in our bourne-shell wrapper script:
> $POSTGRESQL_HOME/bin/createuser -d -P $PGUSER <<END
> $PGPASSWORD
We changed all the clients some time ago to insist on getting passwords
from /dev/tty not stdin. There was a security argument for it, I think,
but I don't recall the reasoning exactly.
regards, tom lane