Question

postgreSQL installation - does not work

0

Dear community, apparently, there is an issue, when installing PostgreSQL (needed according to mendix to migrate data into the database). https://docs.mendix.com/howto/data-models/migrating-your-mendix-database/ The installation does not finish smoothly and I get an error at the end on a post-install-step. So I can not get the data into Mendix. I have found a workaround in the internet with creating user postgres and allowing it into the admin group, but that is not a solution I am looking for. Any oder ideas on how to install the software or get the data into mendix locally?

asked 2024-10-25

Adam Myszkowski

3 answers

Arun Mani G · Answer 1 · 2024-10-25

Hi Adam,

Check you are running the PostgreSQL installer as an administrator. Right-click on the installer and select Run as administrator.

Check any firewall or antivirus restriction is there or not.

Uninstall any previous versions and delete the PostgreSQL data folder.

otherwise uninstall this and delete all folder related to postgresql. Install again. try to install latest version from website.

you can check this video to install again

https://youtu.be/0n41UTkOBb0?si=9ZWDzMucPPPh49Nw

Thanks

Manikandan K · Answer 2 · 2024-10-25

Hi Aadam,

As per stackoverflow, the following method was the solution. use 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)

Hope it helps!

Thanks & Regards,

Manikandan K

Manikandan K · Answer 3 · 2024-10-25

https://stackoverflow.com/questions/77486742/postgresql-16-failed-to-initialise-the-database-cluster-with-initdb