Thread

1. Windows psql changes after 8.1.1

   John DeSoi <desoi@pgedit.com> — 2006-11-23T14:00:57Z

   Hi,
   
   My editor starts a shell session to communicate with psql. On builds  
   after 8.1.1 this is no longer working on Windows. It seems that I'm  
   no longer getting the password prompt (even if using the -W).  
   Everything appears to be the same as before if I run interactively  
   from the command line. I tried to compare the source, but I could not  
   find anything that would explain the difference (and no problems on  
   the Mac).
   
   Any suggestions on where to look?
   
   Thanks and Happy Thanksgiving,
   
   John
   
   
   
   John DeSoi, Ph.D.
   http://pgedit.com/
   Power Tools for PostgreSQL
   
   
   

2. Re: Windows psql changes after 8.1.1

   Magnus Hagander <mha@sollentuna.net> — 2006-11-23T14:12:39Z

   > Hi,
   > 
   > My editor starts a shell session to communicate with psql. On 
   > builds after 8.1.1 this is no longer working on Windows. It 
   > seems that I'm no longer getting the password prompt (even if 
   > using the -W).  
   > Everything appears to be the same as before if I run 
   > interactively from the command line. I tried to compare the 
   > source, but I could not find anything that would explain the 
   > difference (and no problems on the Mac).
   > 
   > Any suggestions on where to look?
   
   Hmm, not sure why that changed after 8.1.1 - I see changes in 8.1.4
   only. But - you're not supposed to send the password over stdin/stdout.
   I would suggest you set the PGPASSWORD environment variable in the
   custom environment. (it's secure on windows)
   
   //Magnus
   
   

3. Re: Windows psql changes after 8.1.1

   John DeSoi <desoi@pgedit.com> — 2006-11-24T14:25:51Z

   Hi Magnus,
   
   I did not use PGPASSWORD because the documentation says it is not  
   secure. I'll give it a try on Windows. Just curious, why is stdin/ 
   stdout insecure if that is what is used for normal interactive  
   operation?
   
   Could you point me to the file that changed in 8.1.4?
   
   Thanks!
   
   John
   
   
   On Nov 23, 2006, at 9:12 AM, Magnus Hagander wrote:
   
   > Hmm, not sure why that changed after 8.1.1 - I see changes in 8.1.4
   > only. But - you're not supposed to send the password over stdin/ 
   > stdout.
   > I would suggest you set the PGPASSWORD environment variable in the
   > custom environment. (it's secure on windows)
   
   
   
   John DeSoi, Ph.D.
   http://pgedit.com/
   Power Tools for PostgreSQL
   
   
   

4. Re: Windows psql changes after 8.1.1

   Magnus Hagander <mha@sollentuna.net> — 2006-11-24T14:40:09Z

   > Hi Magnus,
   > 
   > I did not use PGPASSWORD because the documentation says it is 
   > not secure.
   
   Well, it says "some operating systems allow non-root users to see
   process environment variables via ps". This is very much not the case on
   Windows, so I don't beleive there is any problem with it on windows.
   
   > I'll give it a try on Windows. Just curious, why 
   > is stdin/ stdout insecure if that is what is used for normal 
   > interactive operation?
   
   It's not used for normal interactive operation. The password is
   retreived directly from CON: (just like it does on Unix)
   
   
   > Could you point me to the file that changed in 8.1.4?
   
   It's src/port/sprompt.c.
   
   //Magnus