BUG #17968: installation

Started by PG Bug reporting formalmost 3 years ago5 messagesbugs

noreply@postgresql.org

almost 3 years ago

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.

Manika Singhal

manika.singhal@enterprisedb.com

almost 3 years ago

In reply to: PG Bug reporting form (#1)

Re: BUG #17968: installation

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

Show quoted text

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@enterprisedb.com

almost 3 years ago

In reply to: Manika Singhal (#2)

Re: BUG #17968: installation

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

sandeep.thakkar@enterprisedb.com

almost 3 years ago

In reply to: Sandeep Thakkar (#3)

Re: BUG #17968: installation

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

Manika Singhal

manika.singhal@enterprisedb.com

almost 3 years ago

In reply to: Sandeep Thakkar (#4)

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