Strange error in Windows 10 Pro

On 04/20/2018 07:16 PM, Dale Seaburg wrote:

I am attempting to install a fresh copy of
postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 Pro.  It

This was downloaded from where?

gets near the end of the install when the message says it is attempting
to start the the database server.   There's a long pause, followed by an
error message: "Failed to load SQL modules into the database cluster".
Using File Explorer, i notice the 9.6\base\ folder is empty?  Has anyone
else seen this before?  I have no clue where to look for the issue.

You are running as Admin user?

As a double-check on a different PC with Windows 10 Pro, I get no error
message, and the database is installed correctly.

Dale Seaburg

--
Adrian Klaver
adrian.klaver@aklaver.com

On 04/20/2018 07:52 PM, Dale Seaburg wrote:

Please also reply to list.
Ccing list to put it front of more eyes.

Thanks, Adrian, for suggestion(s).

On 4/20/2018 9:35 PM, Adrian Klaver wrote:

On 04/20/2018 07:16 PM, Dale Seaburg wrote:

I am attempting to install a fresh copy of
postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 Pro.  It

This was downloaded from where?

downloaded from https://www.postgresql.org/download/windows/, selecting
to use the installer pointed to near the beginning of that page.  The
actual website that contained the installer file was:
"https://www.enterprisedb.com/thank-you-downloading-postgresql?anid=209611".

gets near the end of the install when the message says it is
attempting to start the the database server.   There's a long pause,
followed by an error message: "Failed to load SQL modules into the
database cluster". Using File Explorer, i notice the 9.6\base\ folder
is empty?  Has anyone else seen this before?  I have no clue where to
look for the issue.

You are running as Admin user?

I can't say that I was.  Will check this next time (maybe tomorrow) when
I am customer's site.  I didn't even think about right-clicking on the
installer and selecting run-as-admin.  I know I did not deliberately use
Admin user on the test PC mentioned below, and it installed with no
problems.

As a double-check on a different PC with Windows 10 Pro, I get no
error message, and the database is installed correctly.

Dale Seaburg

--
Adrian Klaver
adrian.klaver@aklaver.com

Oops, my mistake.  I'll let this serve the list with what I've tried so
far.  Thanks, Adrian for the reminder.

I hope tomorrow to visit the customer and try the Admin user method of
installing.

Dale

Thanks Adrian for the suggestion of running the installer with Admin
rights.  Unfortunately, I get the same results.  It appears that all of
the folders within C:\Program Files\PostgreSQL\9.6 path are created, and
populated, BUT, when the items in the *data* folder are to be created,
or copied into, it leaves an error message as noted previously.  The
*data* folder is empty.

It's almost as if the PC is missing a critical .dll needed in the *data*
folder filling function (my guess).

Again, I am at a loss as to what to do.

Dale

On 04/21/2018 01:08 PM, Dale Seaburg wrote:

Thanks Adrian for the suggestion of running the installer with Admin
rights.  Unfortunately, I get the same results.  It appears that all of
the folders within C:\Program Files\PostgreSQL\9.6 path are created, and
populated, BUT, when the items in the *data* folder are to be created,
or copied into, it leaves an error message as noted previously.  The
*data* folder is empty.

It's almost as if the PC is missing a critical .dll needed in the *data*
folder filling function (my guess).

Again, I am at a loss as to what to do.

Have you looked at the system logs e.g. Event Viewer?

Dale

On 4/20/2018 11:13 PM, Dale Seaburg wrote:

Oops, my mistake.  I'll let this serve the list with what I've tried
so far.  Thanks, Adrian for the reminder.

I hope tomorrow to visit the customer and try the Admin user method of
installing.

Dale

On 4/20/2018 11:03 PM, Adrian Klaver wrote:

On 04/20/2018 07:52 PM, Dale Seaburg wrote:

Please also reply to list.
Ccing list to put it front of more eyes.

Thanks, Adrian, for suggestion(s).

On 4/20/2018 9:35 PM, Adrian Klaver wrote:

On 04/20/2018 07:16 PM, Dale Seaburg wrote:

I am attempting to install a fresh copy of
postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10
Pro.  It

This was downloaded from where?

downloaded from https://www.postgresql.org/download/windows/,
selecting to use the installer pointed to near the beginning of that
page.  The actual website that contained the installer file was:
"https://www.enterprisedb.com/thank-you-downloading-postgresql?anid=209611".

gets near the end of the install when the message says it is
attempting to start the the database server.   There's a long
pause, followed by an error message: "Failed to load SQL modules
into the database cluster". Using File Explorer, i notice the
9.6\base\ folder is empty?  Has anyone else seen this before?  I
have no clue where to look for the issue.

You are running as Admin user?

I can't say that I was.  Will check this next time (maybe tomorrow)
when I am customer's site.  I didn't even think about right-clicking
on the installer and selecting run-as-admin.  I know I did not
deliberately use Admin user on the test PC mentioned below, and it
installed with no problems.

As a double-check on a different PC with Windows 10 Pro, I get no
error message, and the database is installed correctly.

Dale Seaburg

--
Adrian Klaver
adrian.klaver@aklaver.com

On system hard drive search for the file called bitrock_installer_<some_numbers>.log.
You should find it in Users\<your_account>\AppData\Local\Temp.
This log should provide you with more specific details explaining why data folder is empty.

Regards,
Igor

From: Dale Seaburg [mailto:kg5lt@verizon.net]
Sent: Saturday, April 21, 2018 4:09 PM
To: pgsql-general@lists.postgresql.org
Subject: Re: Strange error in Windows 10 Pro

WARNING: This email originated from outside of Perceptron! Please be mindful of PHISHING and MALWARE risks.

Thanks Adrian for the suggestion of running the installer with Admin rights. Unfortunately, I get the same results. It appears that all of the folders within C:\Program Files\PostgreSQL\9.6 path are created, and populated, BUT, when the items in the data folder are to be created, or copied into, it leaves an error message as noted previously. The data folder is empty.

It's almost as if the PC is missing a critical .dll needed in the data folder filling function (my guess).

Again, I am at a loss as to what to do.

Dale

On 4/20/2018 11:13 PM, Dale Seaburg wrote:
Oops, my mistake. I'll let this serve the list with what I've tried so far. Thanks, Adrian for the reminder.

I hope tomorrow to visit the customer and try the Admin user method of installing.

Dale

On 4/20/2018 11:03 PM, Adrian Klaver wrote:

On 04/20/2018 07:52 PM, Dale Seaburg wrote:

Please also reply to list.
Ccing list to put it front of more eyes.

Thanks, Adrian, for suggestion(s).

On 4/20/2018 9:35 PM, Adrian Klaver wrote:

On 04/20/2018 07:16 PM, Dale Seaburg wrote:

I am attempting to install a fresh copy of postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 Pro. It

This was downloaded from where?
downloaded from https://www.postgresql.org/download/windows/, selecting to use the installer pointed to near the beginning of that page. The actual website that contained the installer file was: "https://www.enterprisedb.com/thank-you-downloading-postgresql?anid=209611&quot;&lt;https://www.enterprisedb.com/thank-you-downloading-postgresql?anid=209611&gt;.

gets near the end of the install when the message says it is attempting to start the the database server. There's a long pause, followed by an error message: "Failed to load SQL modules into the database cluster". Using File Explorer, i notice the 9.6\base\ folder is empty? Has anyone else seen this before? I have no clue where to look for the issue.

You are running as Admin user?
I can't say that I was. Will check this next time (maybe tomorrow) when I am customer's site. I didn't even think about right-clicking on the installer and selecting run-as-admin. I know I did not deliberately use Admin user on the test PC mentioned below, and it installed with no problems.

As a double-check on a different PC with Windows 10 Pro, I get no error message, and the database is installed correctly.

Dale Seaburg

Il 21/04/2018 22:35, Adrian Klaver ha scritto:

On 04/21/2018 01:08 PM, Dale Seaburg wrote:

Thanks Adrian for the suggestion of running the installer with Admin
rights.  Unfortunately, I get the same results.  It appears that all
of the folders within C:\Program Files\PostgreSQL\9.6 path are
created, and populated, BUT, when the items in the *data* folder are
to be created, or copied into, it leaves an error message as noted
previously. The *data* folder is empty.

It's almost as if the PC is missing a critical .dll needed in the
*data* folder filling function (my guess).

Again, I am at a loss as to what to do.

Have you looked at the system logs e.g. Event Viewer?

If you look in %temp%", there should be one or more files named
"bitrock_installer" or something similar (search for "bitrock"), that's
the setup log with what's went good and what not.
Another hint I had since 9.1 times (it was 2012, I guess) was to avoid
installing Postgres under system folders (c:\program files, c:\users,
and so on) because in some cases there could be some nasty behaviors...
try installing on something like c:\PG96...

HTH
Cheers,
Moreno.-

Il 21/04/2018 22:35, Adrian Klaver ha scritto:

On 04/21/2018 01:08 PM, Dale Seaburg wrote:

Thanks Adrian for the suggestion of running the installer with Admin
rights. Unfortunately, I get the same results. It appears that all
of the folders within C:\Program Files\PostgreSQL\9.6 path are
created, and populated, BUT, when the items in the *data* folder are
to be created, or copied into, it leaves an error message as noted
previously. The *data* folder is empty.

Did you try to execute the installer with a local admin? We had a similar issue when the "admin" user was not a local user but somehow a remote admin (sorry I, not an windows expert). When we switched to local admin all was fine and that seemed to be related to group policies

Thanks to Moreno and Igor for the Event Viewer suggestions.  Here are a
few lines of log file where they differ between a good install and a bad
incomplete install.  The good install was from my Shop PC with Windows
10 Pro.

BTW, I had success with another Dell PC with Win 10 Pro about 4 months
ago.  This problem appears to be a one-off.

Good Install:
/Called AclCheck(C:\Program Files\PostgreSQL\9.6\data)//
//Called IsVistaOrNewer()...//
//    'winmgmts' object initialized...//
//    Version:10.//
//    MajorVersion:10//
//Executing icacls to ensure the SHOP-PC\Dale account can read the path
C:\Program Files\PostgreSQL\9.6\data//
//    Executing batch file 'rad0510A.bat'...//
//    processed file: C:\Program Files\PostgreSQL\9.6\data//
//Successfully processed 1 files; Failed processing 0 files/

Bad Install:
/Called AclCheck(D:\PostgreSQL\9.6\data)//
//Called IsVistaOrNewer()...//
//    'winmgmts' object initialized...//
//    Version:10.//
//    MajorVersion:10//
//Executing icacls to ensure the WINDOWS-6BEGVO1\don king account can
read the path D:\PostgreSQL\9.6\data//
//    Executing batch file 'rad6DBC7.bat'...//
//
/Notice the last four lines of the *Good Install* vs the last two lines
of the *Bad Install*.  There is no indication of processing, or whether
it was successful or not in the bad install.

As you can see, I even took Igor's suggestion to install in a non-system
(Program Files) path, to no success.

Again, not sure what to do.  Open for suggestions...  I'm almost ready
to call Dell and complain about a "bad" Win 10 Pro install.

Dale
//

As you may have noticed in the Bad Install section, the user's name was
'don king' - with an embedded space.  I created a new user 'Dale' to
test out whether that name might be causing a problem.  The new name
also failed to complete an install.

Dale

On 04/23/2018 07:09 PM, Dale Seaburg wrote:

Thanks to Moreno and Igor for the Event Viewer suggestions.  Here are a
few lines of log file where they differ between a good install and a bad
incomplete install.  The good install was from my Shop PC with Windows
10 Pro.

BTW, I had success with another Dell PC with Win 10 Pro about 4 months
ago.  This problem appears to be a one-off.

So is the below from the bitrock_installer logs or the Event Viewer logs?

Big difference I notice is C:\ vs D:\.
Where is D:\?

Good Install:
/Called AclCheck(C:\Program Files\PostgreSQL\9.6\data)//
//Called IsVistaOrNewer()...//
//    'winmgmts' object initialized...//
//    Version:10.//
//    MajorVersion:10//
//Executing icacls to ensure the SHOP-PC\Dale account can read the path
C:\Program Files\PostgreSQL\9.6\data//
//    Executing batch file 'rad0510A.bat'...//
//    processed file: C:\Program Files\PostgreSQL\9.6\data//
//Successfully processed 1 files; Failed processing 0 files/

Bad Install:
/Called AclCheck(D:\PostgreSQL\9.6\data)//
//Called IsVistaOrNewer()...//
//    'winmgmts' object initialized...//
//    Version:10.//
//    MajorVersion:10//
//Executing icacls to ensure the WINDOWS-6BEGVO1\don king account can
read the path D:\PostgreSQL\9.6\data//
//    Executing batch file 'rad6DBC7.bat'...//
//
/Notice the last four lines of the *Good Install* vs the last two lines
of the *Bad Install*.  There is no indication of processing, or whether
it was successful or not in the bad install.

As you can see, I even took Igor's suggestion to install in a non-system
(Program Files) path, to no success.

Again, not sure what to do.  Open for suggestions...  I'm almost ready
to call Dell and complain about a "bad" Win 10 Pro install.

Dale

--
Adrian Klaver
adrian.klaver@aklaver.com

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Il 24/04/2018 04:09, Dale Seaburg ha
scritto:<br>
</div>
<blockquote type="cite"
cite="mid:b8898288-f6c6-0ed3-33aa-178766daafed@verizon.net">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<p>Thanks to Moreno and Igor for the Event Viewer suggestions. 
Here are a few lines of log file where they differ between a
good install and a bad incomplete install.  The good install was
from my Shop PC with Windows 10 Pro.</p>
<p>BTW, I had success with another Dell PC with Win 10 Pro about 4
months ago.  This problem appears to be a one-off.<br>
</p>
Good Install:<br>
<i>Called AclCheck(C:\Program Files\PostgreSQL\9.6\data)</i><i><br>
</i><i>Called IsVistaOrNewer()...</i><i><br>
</i><i>    'winmgmts' object initialized...</i><i><br>
</i><i>    Version:10.</i><i><br>
</i><i>    MajorVersion:10</i><i><br>
</i><i>Executing icacls to ensure the SHOP-PC\Dale account can
read the path C:\Program Files\PostgreSQL\9.6\data</i><i><br>
</i><i>    Executing batch file 'rad0510A.bat'...</i><i><br>
</i><i>    processed file: C:\Program Files\PostgreSQL\9.6\data</i><i><br>
</i><i>Successfully processed 1 files; Failed processing 0 files</i><br>
<br>
Bad Install:<br>
<i>Called AclCheck(D:\PostgreSQL\9.6\data)</i><i><br>
</i><i>Called IsVistaOrNewer()...</i><i><br>
</i><i>    'winmgmts' object initialized...</i><i><br>
</i><i>    Version:10.</i><i><br>
</i><i>    MajorVersion:10</i><i><br>
</i><i>Executing icacls to ensure the WINDOWS-6BEGVO1\don king
account can read the path D:\PostgreSQL\9.6\data</i><i><br>
</i><i>    Executing batch file 'rad6DBC7.bat'...</i><i><br>
</i><i></i></blockquote>
<br>
It would be interesting to have the next 2 lines in "Bad install",
like in "good install", to know if rad6DBC7.bat excecution
terminated with or without errors.... so if there's an error it
would be nice to see it.<br>
I assume D: to be a secondary local drive or anyway a local
partition.... not a network or external one...<br>
<br>
Thanks<br>
Moreno.-<br>
</body>
</html>

From: Dale Seaburg [mailto:kg5lt@verizon.net]
Sent: Monday, April 23, 2018 10:10 PM
To: pgsql-general@lists.postgresql.org
Subject: Re: Strange error in Windows 10 Pro

Thanks to Moreno and Igor for the Event Viewer suggestions. Here are a few lines of log file where they differ between a good install and a bad incomplete install. The good install was from my Shop PC with Windows 10 Pro.

BTW, I had success with another Dell PC with Win 10 Pro about 4 months ago. This problem appears to be a one-off.
Good Install:
Called AclCheck(C:\Program Files\PostgreSQL\9.6\data)
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Executing icacls to ensure the SHOP-PC\Dale account can read the path C:\Program Files\PostgreSQL\9.6\data
Executing batch file 'rad0510A.bat'...
processed file: C:\Program Files\PostgreSQL\9.6\data
Successfully processed 1 files; Failed processing 0 files

Bad Install:
Called AclCheck(D:\PostgreSQL\9.6\data)
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Executing icacls to ensure the WINDOWS-6BEGVO1\don king account can read the path D:\PostgreSQL\9.6\data
Executing batch file 'rad6DBC7.bat'...

Notice the last four lines of the Good Install vs the last two lines of the Bad Install. There is no indication of processing, or whether it was successful or not in the bad install.

As you can see, I even took Igor's suggestion to install in a non-system (Program Files) path, to no success.

Again, not sure what to do. Open for suggestions... I'm almost ready to call Dell and complain about a "bad" Win 10 Pro install.

Dale

Dale,
The problem isn’t in “bad” Win10 Pro install.
The problem is that Win10 on this machine is configured differently from Win10 machine where your install worked fine.
In Windows there is a “default” association between file types/extensions and programs that execute these files by default. Batch files like 'rad6DBC7.bat' shouldn’t have any association, Win OS knows that this type should be executed by OS, like .exe types. But sometimes Windows users change it, and associate .bat files with Notepad (or some other text editor) in order to be able to edit batch scripts. By the way, batch file names are different in “good” and “bad” installations because those are temporary files created by vbs scripts that are running during install.
So, in order to fix this you need to dissociate .bat type/extension from Notepad, or whatever text editor it is associated on the “bad” Windows. If you don’t know where to look for this feature in Win OS, ask someone who’s more familiar with windows environment.
Pretty sure that’s the solution of your problem.
Regards,
Igor Neyman

Just to put a finishing note to this thread:

I am placing the blame on the mfg of the PC - was supposed to be a NEW,
but had a Reburbished sticker on the bottom of the case.  Now, whether
it was the PC mfg or Microsoft's fault, I really could care less - the
PC became useless for installing PostgreSQL - versions 8.4.5, 9.6.7 or
10.3.  The install ALWAYS failed at the very last step - the building of
the internal folders, etc of the *data* folder.

So, in frustration, I have chosen to install 8.4.5 on an older PC
running XP.  It just works!  I don't like it, but I am constrained by
the owner's wishes.

Thanks, for offering each of your individual helps.

Regards,
Dale Seaburg