Gary Horton wrote:
...and in 7.3.4, this works just fine, with the shell consuming the stdin and redirecting it to the createuser command, which subsequently doesn't bother the user with the prompt (i.e. the prompts are responded to automatically). However, this doesn't work at all in 8.1.0 -- regardless of the stdin redirection, the createuser program appears to ignore the stdin information and insists on prompting for the input instead.
Don't know what's changed, but it could be something that happened when roles were introduced. A way to work around it would be to issue the SQL "CREATE USER... PASSWORD 'foo'" via psql.
Oh - anything else you come across in the upgrade would be of interest to many here, myself included ;-)
-- Richard Huxton Archonet Ltd
