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