Gary Horton wrote: > > > Richard Huxton wrote: > > > 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. > > That's a great idea, Richard - thanks, I'll give this a shot --
createuser was converted from a shell script to a C program in 7.4, so I guess something changed at that point. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
