Re: [GENERAL] Reading psql password from stdin

2001-10-14 Thread Bruce Momjian
Oops, sorry, I see my question was answered. --- > Correction: > The password promps only end up in the dumpfile for version 6.5. > > pg_dump does wait and prompt for passwords if you use -u for version 7.1.x. > > Cheerio

Re: [GENERAL] Reading psql password from stdin

2001-10-14 Thread Bruce Momjian
The proposed patch would fix this. Password prompts would go to the terminal. Right now they got to stderr. Does your stderr go to the dump file? > pg_dump does wait for passwords - version 7.1.x. > > But the password prompts end up in the dumpfile. > > That is to say, the Username: and/o

Re: [GENERAL] Reading psql password from stdin

2001-10-14 Thread Lincoln Yeoh
Correction: The password promps only end up in the dumpfile for version 6.5. pg_dump does wait and prompt for passwords if you use -u for version 7.1.x. Cheerio, Link. At 06:19 PM 14-10-2001 -0600, Keary Suska wrote: >Good, good, very good! being one of the people who steadfastly avoids PGUSER

Re: [GENERAL] Reading psql password from stdin

2001-10-14 Thread Lincoln Yeoh
pg_dump does wait for passwords - version 7.1.x. But the password prompts end up in the dumpfile. That is to say, the Username: and/or Password: prompts end up in the dumpfile and are not displayed on the screen. Cheerio, Link. At 06:19 PM 14-10-2001 -0600, Keary Suska wrote: >Good, good, ver

Re: [GENERAL] Reading psql password from stdin

2001-10-14 Thread Keary Suska
Good, good, very good! being one of the people who steadfastly avoids PGUSER and PGPASSWORD for security reasons, it would be nice t be able to do $ psql db user < file As the docs say you can. Would this change also allow the use of: $ pg_dump > dumpfile Which doesn't work when prompting