i have the same error i tryed diffrent domains but if i didnt creat it in windows it tells me “internal account lookup failure” and if i made a account it said it allready exist.

昨天装postgresql，装到最后居然出了错，折腾了半天才搞定，看来还是需要多动脑多思考多尝试，才能解决问题。

错误信息如下：

Internal account lookup failure: No mapping between account names and security IDs was done

后来上网查了相关信息，才知道在安装时填写的用户必须是另一个受限制的用户，但还必须是同一个群组的才行。

Which apparently suggests an issue with the machine setup (it being a domain controller or running an active directory) according to the link below:

http://pgfoundry.org/pipermail/pginstaller-devel/2006-September/000803.html

It suggest creating an account manually with LIMITED access and using that account during the installation, instead of letting the installer create an account.

所以，先给系统创建了一个新用户：postgreSQL，并给它设了密码和限制。

再次安装的时候，需要填写用户是就填写刚才创建的就可以了，密码也是同样的。

一路“next”，就”finish”了

转载请注明：夜阑小雨 » Postgresql 出错"internal account lookup failure" 解决办法