Trying to install PostgreSQL for class on Windows 11

[Mme-George]

Here are the instructions we were provided:

1. Download the PostgreSQL installer from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
2. During installation, UNCHECK "pgAdmin4"
3. Set the database password (I liked to set it to admin )
4. Complete the install
5. DO NOT launch StackBuilder
6. Navigate to: https://www.pgadmin.org/download/pgadmin-4-windows/
7. Download the latest Windows installer
8. Launch pgAdmin 4 (It might take a 1-2 minutes to load)
9. Type in your password from step 3
10. pgAdmin will now be up and running

I have attempted to install the PostgreSQL installer more than a dozen times, attempting to troubleshoot as I go. Initially I was receiving an error that the data file failed to initialize and I found a source that said this was likely due to the Windows security. I disabled that and now I'm getting, "Problem running post-install step. Installation may not complete correctly. The database cluster installation failed."

This is a copy of the info from the latest installation attempt using English, United States.

Installation Directory: C:\Program Files\PostgreSQL\17
Server Installation Directory: C:\Program Files\PostgreSQL\17
Data Directory: C:\Program Files\PostgreSQL\17\data
Database Port: 5432
Database Superuser: postgres
Operating System Account: NT AUTHORITY\NetworkService
Database Service: postgresql-x64-17
Command Line Tools Installation Directory: C:\Program Files\PostgreSQL\17
Stack Builder Installation Directory: C:\Program Files\PostgreSQL\17
Installation Log: C:\Users\Sarah's Home Laptop\AppData\Local\Temp\install-postgresql.log

Can someone please gently walk me through getting this installed? I'm not an idiot, but this is beyond my abilities to understand what I might be doing wrong.

[sandeep-edb]

Hi, I assume the installer filename you tried installing is postgresql-17.5-3-windows-x64.exe ?

Since your username contains a space, I created a new account "sandeep's home" on my Windows Server 2022 instance but was able to install the installer successfully. I'll have to see the installation log that's created on your system to understand the cause of the error. Can you please attach "C:\Users\Sarah's Home Laptop\AppData\Local\Temp\install-postgresql.log" to this ticket?

[Mme-George]

My apologies for the delay.

install-postgresql.log

[sandeep-edb]

I'm not sure what is causing this, but I made few changes in the initcluster script. Can you please download the "test" installer from https://get.enterprisedb.com/test-installers/postgresql-17.5-0.0snapshot16722657301.1306.2.a356107.3-windows-x64.exe install it and confirm how it went? Thanks

[Mme-George]

It worked! Thank you so, so much.

[sandeep-edb]

Than you for the confirmation. The fix should be included in the next week PostgreSQL maintenance release