Thread: postgresql-9.3.4-1-windows-x64 installer - Problem with strong passwords
postgresql-9.3.4-1-windows-x64 installer - Problem with strong passwords
From
Richard DeVenezia
Date:
Hello group: I attempted an install on Window 2008 Server R2 with postgresql-9.3.4-1-windows-x64.exe. Option choices was easy Install location, default C:\Program Files\.... Data location, set to D:\XYZ\pgdata Password: ULv&94T;)7--S;< Port: 5432 The password was output by a strong password generator. The install went ok until it was time to run some batch files that the installer creates. The installer creates a batch file containing a set statement such as SET PGPASSWD=ULv&94T;)7--S;< Windows really hates special characters and can not set the password properly and probably fails behind the scenes. Eventually a dialog appears saying the install probably didn't work properly (because a conf file in the pgdata folder was not found) The installer should be updated to disallow any characters that will not work in the generated batch files, or properly generate a batch file with appropriate DOS escapes, for examle SET PGPASSWD=ULv^^^&94T^^^;^^^)7--S^^^;^^^< Richard