Re: createuser ignores stdin in 8.1.0?

[Gary Horton <Gary.Horton@xxxxxxx>]

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@xxxxxxx> 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