Re: createuser ignores stdin in 8.1.0?

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(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
>
>