Dear PostgreSQL community,
I hope this is the right place for my concern.
Today I discovered a strange behaviour of the Windows Installer of PostgreSQL.
While migrating an application database from MSSQL, the Postgres setup did not seem to complete correctly and had problems starting the Postgres service after installation. I found that the service did not seem to be created at all.
After some trying around with help I found online, trying non-domain users and some other stuff that was proposed for the problem, I found the problem lay in my chosen password. My password was randomly generated with alphanumeric + special characters. While this did not work, switching to alphanumeric-only passwords seemed to solve the problem. I suspect that the quotation marks in particular are causing problems in the setup, as they seem to terminate some strings prematurely in the scripts used by the installer.
My setup was as follows:
OS: Windows Server 2019, also tested on Windows Server 2022
PSQL version: 16.3 (latest installer from EDB)
Steps to reproduce:
1. Run the installer
2. Enter any password that contains quotation marks
3. The installer should fail at the end and report some errors.
Could you please help me investigate this, is this a known problem or is there even a known workaround? If this is not a known issue, can you help me point this report in the right direction so that it can be addressed?
Best regards,
Timo