psql:严重:用户"postgres"的身份验证失败. [英] psql: FATAL: Ident authentication failed for user "postgres"

问题描述

我已经在Ubuntu Karmic盒子上安装了PostgreSQL和pgAdminIII.

I have installed PostgreSQL and pgAdminIII on my Ubuntu Karmic box.

我能够成功使用pgAdminIII(即连接/登录)，但是当我尝试在命令行上使用相同的用户名/pwd(使用psql)登录服务器时，出现错误:

I am able to use pgAdminIII successfully (i.e. connect/log on), however when I try to login to the server using the same username/pwd on the command line (using psql), I get the error:

psql: FATAL:  Ident authentication failed for user "postgres"

现在有人可以解决此问题吗?

Does anyone now how to resolve this issue?

推荐答案

您是否在pg_hba.conf中设置了正确的设置?

Did you set the proper settings in pg_hba.conf?

请参见 https://help.ubuntu.com/stable/serverguide/postgresql.html 怎么做.

这篇关于psql:严重:用户"postgres"的身份验证失败.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！