Win 11 Postgresql 16 安装失败

Jun 16, 2024#postgresql87

AI-generated summary

The installation of Win 11 Postgresql 16 failed due to errors during installation and initialization, possibly caused by modifying the cmd encoding format. The solution involves resetting the Autorun value in the registry editor and reinstalling Postgresql.

主要遇到以下两个问题

一个是在安装时报错

Problem running post-install step. Installation may not complete correctlyThe database cluster initialisation failed.

一个是在初始化时报错

The program "postgres" was found by "initdb" but was not the same version as initdb.

出现问题的原因是曾经修改过 cmd 的编码格式

解决步骤：

win+R
输入 regedit
找到 计算机\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Command Processor
将 Autorun 置空
重新安装 Postgresql

参考：https://stackoverflow.com/questions/54631443/win-10-postgresql-11-database-cluster-initialisation-failed