Feedback-ID: i76984098:Fastmail
Message-ID: <fb5384cd-8f67-4dcd-ae05-7851e7ad68ef@aklaver.com>
Date: Fri, 31 May 2024 14:57:04 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Issue with PostgreSQL Installer on Windows and Special Characters
 in the superuser password
To: Timo Schwaak <timo.schwaak@icloud.com>, pgsql-general@lists.postgresql.org
References: <35f280da-6547-458c-90ec-1d946c269f9f@me.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <35f280da-6547-458c-90ec-1d946c269f9f@me.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/fb5384cd-8f67-4dcd-ae05-7851e7ad68ef%40aklaver.com>
Precedence: bulk

On 5/31/24 14:18, Timo Schwaak wrote:
> 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?

1) Don't use passwords with quotation marks.

2) Contact https://www.enterprisedb.com/ and file an issue with them.
The installer is their product not part of the community distribution.

3) Poke pgadmin-support here:

https://www.postgresql.org/list/pgadmin-support/

That is from EDB also, maybe someone over there can help.

4) Jump on this thread at pgsql-bugs about installer :

https://www.postgresql.org/message-id/flat/DU0PR10MB71447B1C6946731AD6C73D13C0E72%40DU0PR10MB7144.EURPRD10.PROD.OUTLOOK.COM

Or start a new one here:

https://www.postgresql.org/account/login/?next=/account/submitbug/

> 
> 
> Best regards,
> 
> Timo

-- 
Adrian Klaver
adrian.klaver@aklaver.com