Thread

1. BUG #17968: installation

   PG Bug reporting form <noreply@postgresql.org> — 2023-06-11T08:28:07Z

   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.
   
   

2. Re: BUG #17968: installation

   Manika Singhal <manika.singhal@enterprisedb.com> — 2023-06-12T10:02:51Z

   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.
   > 
   
   

3. Re: BUG #17968: installation

   Sandeep Thakkar <sandeep.thakkar@enterprisedb.com> — 2023-07-03T06:46:34Z

   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
   

4. Re: BUG #17968: installation

   Sandeep Thakkar <sandeep.thakkar@enterprisedb.com> — 2023-07-06T13:44:34Z

   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
   

5. Re: BUG #17968: installation

   Manika Singhal <manika.singhal@enterprisedb.com> — 2023-07-13T13:04:48Z

   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.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