postgresql-9.3.4-1-windows-x64 installer - Problem with strong passwords

From: Richard DeVenezia <rdevenezia(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: postgresql-9.3.4-1-windows-x64 installer - Problem with strong passwords
Date: 2014-04-01 21:51:01
Message-ID: CACT-pRyMcACeLCquuaUT7HsRwk2eG8FGr37HorwTAALmrxLDLA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2014-04-01 22:43:15 Re: Timezone error when casting. Maybe daylight saving
Previous Message Kjetil Nygård 2014-04-01 20:53:57 Re: Timezone error when casting. Maybe daylight saving