Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Install Error- Database Cluster Initialisation Failed - Windows 10 #179

Open
fabulous-fabio opened this issue Oct 23, 2024 · 14 comments
Open

Comments

@fabulous-fabio
Copy link

Hello,
When trying to install Postgres using the provided installer, I keep encountering the following error:

I've already attempted using different versions of the installer, but the same issue occurs every time.

67bf2ad8-cd4c-4ed0-bef6-145a43becf13

Has anyone else experienced this problem or knows what might be causing it? I'm feeling quite stuck at this point.

Kind regards,
Fabio

@fabulous-fabio fabulous-fabio changed the title Postgresql 17 Installation Error on Windows 10 Postgresql 17 - database cluster initialisation failed - Windows 10 Oct 23, 2024
@Im1Bear
Copy link

Im1Bear commented Oct 23, 2024

I have the same Issue, tried changing the Language for the Installation but didn't change a thing, I tried following a Stackoverflow Post, but also didn't work.

@fabulous-fabio fabulous-fabio changed the title Postgresql 17 - database cluster initialisation failed - Windows 10 Install Error- Database Cluster Initialisation Failed - Windows 10 Oct 24, 2024
@sandeep-edb
Copy link
Contributor

Hi,
Could you please share the installer filename? Also, if you can share the installation log file that must have created by the installer in system TEMP location?

@Im1Bear
Copy link

Im1Bear commented Oct 24, 2024

Hi, Could you please share the installer filename? Also, if you can share the installation log file that must have created by the installer in system TEMP location?

install-postgresql.log

@sandeep-edb
Copy link
Contributor

Thanks, I checked the log and observed that it's German OS. Is that correct? I'm guessing the default service account that the installer uses to run the postgres service "NT AUTHORITY\NetworkService" doesn't exist on your system. It must be something else.

Could you try running the installer EXE on the command prompt with the option "--serviceaccount <the_name_that_exist_for_networkservice> ?

@Im1Bear
Copy link

Im1Bear commented Oct 24, 2024

Yes, the German OS is correct,
I've tried running the EXE with Powershell,
Start-Process C:\Users\Admin\Downloads\postgresql-17.0-1-windows-x64.exe --serviceaccount
but it doesn't work (with the Name).

@sandeep-edb
Copy link
Contributor

sandeep-edb commented Oct 25, 2024

OK, could you share the installation log so I see if it made any difference?

Also, if you could share the output of the command:
wmic sysaccount where SID="S-1-5-20" get name

@Im1Bear
Copy link

Im1Bear commented Oct 25, 2024

The Logs didn't change.

Output for the Command:
Invalid parameter for this level.
Doesn't change if I use any other Terminal or change Folder Location. Maybe someone else can give more insight?

@sandeep-edb
Copy link
Contributor

You mean you tried the
Start-Process C:\Users\Admin\Downloads\postgresql-17.0-1-windows-x64.exe --serviceaccount <snetworkservice_account_name_on_your_os> ? Please share the installation log of this.

@moerwald
Copy link

@Im1Bear did you catch this log-entry?

CScript-Fehler: Der Zugriff auf Windows Script Host wurde f�r diesem Computer deaktiviert. Wenden Sie sich an Ihren Administrator, um weitere Details in Erfahrung zu bringen.

@Im1Bear
Copy link

Im1Bear commented Oct 28, 2024

I am currently not at home and will get in touch later.

@Im1Bear
Copy link

Im1Bear commented Oct 28, 2024

@Im1Bear did you catch this log-entry?

CScript-Fehler: Der Zugriff auf Windows Script Host wurde f�r diesem Computer deaktiviert. Wenden Sie sich an Ihren Administrator, um weitere Details in Erfahrung zu bringen.

Yes, I get this message daily, because I deactivated Windows Script Host.
I've now activated it.
I'm no longer considering using PostgreSQL and now use MongoDB, because of Issues like this, if I need more help to install something like PostgreSQL, rather than developing something with it, I simply won't use it.
Furthermore, I'm still open to helping with issues currently open, but I'm not going to use PostgreSQL.

You mean you tried the Start-Process C:\Users\Admin\Downloads\postgresql-17.0-1-windows-x64.exe --serviceaccount <snetworkservice_account_name_on_your_os> ? Please share the installation log of this.

I've tried using this Command, with any Username I could imagine, it just didn't work.

@yunofsea
Copy link

Hi,I encountered this porblem today,and I fixed it by choosing the locale "English US"

@sandeep-edb
Copy link
Contributor

The PostgreSQL 17.2-2, 16.6-2, 15.10-2 are available for download. These installers include a fix for system installation issue.

@surebrec
Copy link

surebrec commented Dec 18, 2024

the error is still being reproduced in Win 10 [postgresql-17.2-3-windows-x64.exe]

ўлЇ®«­пҐвбп § Є«озЁвҐ«м­ п Ё­ЁжЁ «Ё§ жЁп... 2024-12-18 13:41:03.511 MSK [644] FATAL: invalid byte sequence for encoding "UTF8": 0xe7 0xf4 0xfb

install-postgresql.log

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

6 participants