Thanks, Tom, that explains it. I'm using Richard Huxton's suggested workaround and it's working just fine -
-gh
Tom Lane wrote:
Gary Horton <Gary.Horton@Sun.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