Re: createuser ignores stdin in 8.1.0? - Mailing list pgsql-general

From Tom Lane
Subject Re: createuser ignores stdin in 8.1.0?
Date
Msg-id 7121.1133557591@sss.pgh.pa.us
Whole thread Raw
In response to createuser ignores stdin in 8.1.0?  (Gary Horton <Gary.Horton@Sun.COM>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Adding order bys to the view definitions (7.4)
Next
From: "Karl O. Pinc"
Date:
Subject: New.* and old.* as function arguments within rules