POSTGRESQL 16 - Failed to initialise the database cluster with initdb

Question

Hello i am 2 days stuck trying to install POSTGRE SQL. Today it is on version 16 but already attempted versions 14, 13, 15....

It looks like the bin\data folder, which is the db cluster folder, has some kind of structure and on the end of installation i get a POP UP , indicating that the folder setup for the db clusters was not configured right.

I am installing this because i need to run a django project.

This log i got from C:\Program Files\PostgreSQL\16\installation_summary.log:

Processados com sucesso 1 arquivos; falha no processamento de 0 arquivos

Called IsVistaOrNewer()... 'winmgmts' object initialized... Version:10. MajorVersion:10 Granting full access to Administrators on (C:\PostgreSQL\data)

Executing batch file 'rad30F8E.bat'... arquivo processado: C:\PostgreSQL\data Processados com sucesso 1 arquivos; falha no processamento de 0 arquivos

Executing batch file 'rad30F8E.bat'... processo filho terminou com c¢digo de sa¡da 1 initdb: erro: O programa "postgres" ‚ requerido pelo initdb mas nÆo foi encontrado no mesmo diret¢rio que "C:/Program Files/PostgreSQL/16/bin/initdb.exe"

Called Die(Failed to initialise the database cluster with initdb)... Failed to initialise the database cluster with initdb

Script stderr: Program ended with an error exit code

Error running C:\WINDOWS\System32\cscript //NoLogo "C:\Program Files\PostgreSQL\16/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\Users\Administrador\AppData\Local\Temp/postgresql_installer_afbe97298d" "C:\Program Files\PostgreSQL\16" "C:\PostgreSQL\data" 5432 "Portuguese,Brazil" 0: Program ended with an error exit code Problem running post-install step. Installation may not complete correctly The database cluster initialisation failed. Setting variable whoami from C:\WINDOWS\System32\whoami Script exit code: 0

Script output: desktop-peu5949\administrador

When it finishes installing i don't get a windows service of the postgreSQL

Attempted:

Solution1

Solution2

Solution3

Answer 1

After hours of struggle, the following method was the solution for me. I used this link for the solution:

PostgreSql "running post install step…the Database Cluster Initialisation failed"

-- to create and run Postgresql database settings after installation :

"C:\Program Files\PostgreSQL\16\initdb.exe" -D "C:\Program Files\PostgreSQL\16\data" -U postgres --locale="English_United States.1252"

-- to create and run the Postgresql service:

"D:\PostgreSQL\16\bin\pg_ctl.exe" register -N postgresql-x64-16 -D "D:\PostgreSQL\16\bin\data"

There are a few details that I would like to draw attention to: My local computer has the settings Turkish_Turkey.1254. This is exactly how my previous Postgres installations were configured.

The problem seems to be related to windows update or EnterpriseDB deployment settings. However, I am not sure which one exactly caused this error.

The two lines above did exactly what I needed when I ran them from the command line (with administrator rights)

Answer 2

After the first installation failed, I tried to install again, but this time I selected "English — United States" as language. And also change data directory to new file "postgres data" on Desktop. It worked. But still had to add paths for psql.