postgresql-9.3.4-1-windows-x64 installer - Problem with strong passwords - Mailing list pgsql-bugs

From Richard DeVenezia
Subject postgresql-9.3.4-1-windows-x64 installer - Problem with strong passwords
Date
Msg-id CACT-pRyMcACeLCquuaUT7HsRwk2eG8FGr37HorwTAALmrxLDLA@mail.gmail.com
Whole thread Raw
List 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

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: GiST does palloc's in critical section
Next
From:
Date:
Subject: Configuring Standby Server in PostgreSQL 9.3.3