Re: BUG #17968: installation

Hi,
We suspect that your issue is related to the application that your system
uses to open .bat files as mentioned in the previous email.
We addressed this issue in our recently released installer with package
revision no.3 (postgresql-15.3-3-windows-x64.exe).
Please try this one, and let us know if the issue still persists.
Try downloading the installer from
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

--
Thanks & Regards
Manika Singhal
EDB Pune

On 06-Jul-2023, at 7:14 PM, Sandeep Thakkar <
sandeep(dot)thakkar(at)enterprisedb(dot)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(dot)thakkar(at)enterprisedb(dot)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(dot)singhal(at)enterprisedb(dot)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(at)postgresql(dot)org>
>> wrote:
>>
>> The following bug has been logged on the website:
>>
>> Bug reference: 17968
>> Logged by: akinkunmi Sowande
>> Email address: serialalphaomega(at)googlemail(dot)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