Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432

This sounds a good news for all Asia-Pacific region users using non english characters in the installation directory.

joe(dot)zhou(at)dualhelios(dot)com

From: Sandeep Thakkar
Date: 2024-05-09 18:09
To: 周志勤
CC: Thomas Munro; Laurenz Albe; pgsql-bugs; Muralikrishna Bandaru
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
Ah I got it now. So the installation looks good.

Please note the PostgreSQL maintenance releases will be available for download today. They will include this fix.

Thank you

On Thu, May 9, 2024 at 3:06 PM 周志勤 <joe(dot)zhou(at)dualhelios(dot)com> wrote:
Hi,Sandeep

See my comments/answers inline in pink.

joe(dot)zhou(at)dualhelios(dot)com

From: Sandeep Thakkar
Date: 2024-05-09 17:06
To: 周志勤
CC: Thomas Munro; Laurenz Albe; pgsql-bugs; Muralikrishna Bandaru
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
Hi Joe,

Looking at the installation log, it seems the installer is not returning the reported error message but I see the post installation steps like creation of cluster and starting of the services missing.
[Joe]: pgadmin was the only component i selected to install, as this was the error I encoutered last time. No database installation, I guess this explain no service starting etc.

Are you running the installer with a non-admin user account?
[Joe]: No, with admin.

Or did you run the installer in the extract-only mode?
[Joe]: only pgadmin installation.

On Thu, May 9, 2024 at 1:14 PM 周志勤 <joe(dot)zhou(at)dualhelios(dot)com> wrote:
Hi Sandeep

I have installed the test package you delivered. The installation is succesful with installation log attached.

Please check the log to see if you can close the issue.

Best regards,
Joe

joe(dot)zhou(at)dualhelios(dot)com

From: Sandeep Thakkar
Date: 2024-05-09 00:04
To: 周志勤
CC: Thomas Munro; Laurenz Albe; pgsql-bugs; Muralikrishna Bandaru
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
Hi,

We have identified a bug in the PostgreSQL installer and fixed it. But with further testing of the generated installer, we are seeing an intermittent issue with the ACL on the data directory and starting of the service. Would it be possible for you to install the test installer and confirm if the installation is successful ? The test installer (not for production use) is available for download here

thanks

On Mon, May 6, 2024 at 7:39 AM 周志勤 <joe(dot)zhou(at)dualhelios(dot)com> wrote:
Hi,Thomas

Thanks for your quick response.

If I understand what you mentioned below correctly, I suppose the issue is on the right place,i.e. EDB PostgreSQL installer and Sandeep is working on that.

If it turns out to be some connecting issue in pgadmin or even postgreSQL after Sandeep's investigation, then we can turn to them respectively. Correct?

Best regards,
Joe

joe(dot)zhou(at)dualhelios(dot)com

From: Thomas Munro
Date: 2024-05-06 09:37
To: 周志勤
CC: Laurenz Albe; pgsql-bugs; Sandeep Thakkar; pgsql-bugs-owner
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
On Mon, May 6, 2024 at 1:15 PM 周志勤 <joe(dot)zhou(at)dualhelios(dot)com> wrote:
> I have reported a bug on postgreSQL on the bug in the title as you advised.
>
> However it has been rejected by postgreSQL as they think it should be reported on pgadmin.
>
> Do you have any coordination mechnism bewteen pgadmin and postgresql to avoid ping-pong there ? or I have some misuderstanding there?

Hi Joe,

https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be still open, no?

Note there are three separate projects here:

1. PostgreSQL (that's what this mailing list, pgsql-bugs, is about)
2. EDB PostgreSQL installer for Windows
3. PGAdmin (a GUI for using PostgreSQL)

As far as I can tell so far, the problem you reported is in #2, and that https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be in the right place to talk to the right people about that, or if not, hopefully they will explain why not. As for why you saw that error when you were installing PGAdmin, leading to the first ping-pong cycle, perhaps the Windows installer for #3 also installs #2 or something like that? I dunno because I don't use Windows or those installers myself... I was just trying to redirect things to the right people... Hopefully there will be a response there!

--
Sandeep Thakkar

--
Sandeep Thakkar

--
Sandeep Thakkar