On Mon, Oct 10, 2005 at 06:25:59PM -0700, John Shin wrote: > It seems that for v8.0.4 the createlang will not take .pgpass inputs and > always prompts for password. Is this broken for the new version? Well, > now I have to type in the password for my database script. > > -bash-3.00$ createdb test -h localhost -U postgres > CREATE DATABASE
Is that the exact command you ran? As shown it should fail with a syntax error because the options are in the wrong place: % createdb test -h localhost -U postgres createdb: too many command-line arguments (first is "localhost") Try "createdb --help" for more information. > -bash-3.00$ createlang plpgsql test -h localhost -U postgres > Password: Likewise: % createlang plpgsql test -h localhost -U postgres createlang: too many command-line arguments (first is "-h") Try "createlang --help" for more information. Use the --help option or consult the createlang documentation to see the correct order of options and arguments. It works fine here with .pgpass if the syntax is correct; have you run "createlang --version" to verify that you're running the 8.0.4 version? -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org