Re: BUG #17968: installation - Mailing list pgsql-bugs

On 06-Jul-2023, at 7:14 PM, Sandeep Thakkar <sandeep.thakkar@enterprisedb.com> wrote:

Hi,

Could you please confirm what the .bat files are registered to open with on your system? There is another reported the similar issue and we suspect it's the same cause

On Mon, Jul 3, 2023 at 12:16 PM Sandeep Thakkar <sandeep.thakkar@enterprisedb.com> wrote:

Hi,

We are unable to reproduce the issue at our end. If we look at the shared log, it's failing while executing the temporary batch file:

Executing C:\WINDOWS\System32\cscript //NoLogo "D:\programme_files\PostgreSQL/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\Users\seria\AppData\Local\Temp/postgresql_installer_cdd7543d7f" "D:\programme_files\PostgreSQL" "D:\programme_files\PostgreSQL\data" 5432 "English,UnitedKingdom" 0
Script exit code: 1

Script output:
 WScript.Shell Initialized...
Scripting.FileSystemObject initialized...

Called CreateDirectory(D:\programme_files\PostgreSQL\data)...
Called CreateDirectory(D:\programme_files\PostgreSQL)...
Called ClearAcl (D:\programme_files\PostgreSQL\data)...
    Executing batch file 'rad05D92.bat'...
Called Die(Failed to reset the ACL (D:\programme_files\PostgreSQL\data))...
Failed to reset the ACL (D:\programme_files\PostgreSQL\data)

Script stderr:
 Program ended with an error exit code

Ths batch script would just execute the icacls command on the data directory. something like:

Called ClearAcl (C:\PostgreSQL\15\data)...
    Executing batch file 'rad8DFFA.bat'...
    C:\PostgreSQL\15\data NT SERVICE\TrustedInstaller:(I)(F)
                      NT SERVICE\TrustedInstaller:(I)(CI)(IO)(F)
                      NT AUTHORITY\SYSTEM:(I)(F)
                      NT AUTHORITY\SYSTEM:(I)(OI)(CI)(IO)(F)
                      BUILTIN\Administrators:(I)(F)
                      BUILTIN\Administrators:(I)(OI)(CI)(IO)(F)
                      BUILTIN\Users:(I)(RX)
                      BUILTIN\Users:(I)(OI)(CI)(IO)(GR,GE)
                      CREATOR OWNER:(I)(OI)(CI)(IO)(F)
                      APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES:(I)(RX)
                      APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES:(I)(OI)(CI)(IO)(GR,GE)
                      APPLICATION PACKAGE AUTHORITY\ALL RESTRICTED APPLICATION PACKAGES:(I)(RX)
                      APPLICATION PACKAGE AUTHORITY\ALL RESTRICTED APPLICATION PACKAGES:(I)(OI)(CI)(IO)(GR,GE)

Successfully processed 1 files; Failed processing 0 files

 One way to debug is when you encounter this error, instead of clicking "OK" on the error window, please check the installation log in the System TEMP, get the batch file name, and try to execute it (you may find the file besides the installation log in system TEMP) on the command prompt?

Also, if possible could you share the output of:
> C:\WINDOWS\System32\icacls "D:\programme_files\PostgreSQL\data"

On Mon, Jun 12, 2023 at 3:33 PM Manika Singhal <manika.singhal@enterprisedb.com> wrote:

Hi,

Can you please share the installation log? It must be present in system TEMP with the name starting with installbuilder or install-edb.

--
Thanks & Regards
Manika Singhal
EDB Pune

On 11-Jun-2023, at 1:58 PM, PG Bug reporting form <noreply@postgresql.org> wrote:

The following bug has been logged on the website:

Bug reference:      17968
Logged by:          akinkunmi Sowande
Email address:      serialalphaomega@googlemail.com
PostgreSQL version: 15.3
Operating system:   Windows
Description:        

Hi,
I am having issues installing POSTgresql on my system has two drives (C and
D)Windows 10 EneterpriseDell Inspirion 15X64RAM:16GBNVIDIA GEFORCE GTX
when I try to install the software I receive the below error messages
(postgresql-15.3-2-windows-x64.exe)
i. Failed to load SQL modules into the database cluster

ii. problem running post-install step. installation may not complete
correctly. the database cluster initialisation failed

I have tried countless of times to uninstall and  re-install.

--

Sandeep Thakkar

--

Sandeep Thakkar