The following bug has been logged on the website:
Bug reference: 18626
Logged by: Tom Nies
Email address: tomnies.conclusion@gmail.com
PostgreSQL version: 17rc1
Operating system: Windows
Description:
Hello. This week I installed Postgres 17.RC1 from this website
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads.
During the installation I was asked for a password. I created a random
password with my password manager and used it. The installation failed.
I tried the installation of multiple postgres versions (17.RC1, 16.4 and
13.16) and every time during installation when a password was requested, I
entered the password I already generated in my password manager. The
installation failed every time.
Here are some of the error messages I got:
"Error stating service postgresql-x64-13"
"Failed to load SQL modules into the database cluster."
"Problem running post-install step. Installation may not complete correctly.
Error reading file C:/Program Files/PostgreSQL/13/data/postgresql.conf".
After a lot of searching online I found the following comment on
stackexchange:
"I know the one-click installer breaks (or used to break) with passwords
that have an ampersand in them."
https://dba.stackexchange.com/a/42677
I checked my password manager and my password indeed contained an ampersand
(&). I changed my password to a password with only letters and numbers.
Then, I reinstalled the last version I downloaded (13.16), used the new
password and the installation succeeded. Which leads me to believe the
comment on stackexchange was true and the ampersand resulted in a failed
installation.
I expected the installer to give me a warning or message that an ampersand
should not be used in the password if this results in a crash, but this was
not the case. If some characters are not allowed in passwords, it would be
great if the passwords were not accepted or at least a warning message is
shown.
