-
标题
FATAL: Ident authentication failed for user "postgres" -
说明
When attempting to configure or browse the PostgreSQL plug-in, the following error occurs
* Failed to logon:
Login Failed.
Reason : FATAL: Ident authentication failed for user "postgres"
Check if database cluster is running?
Check if following values are correct?
Port Number
SuperUser name
Password
Database Used for Initial Connection
-
原因
1. The localhost is not mapped within /etc/hosts or not ordered properly
# cat /etc/hosts#127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain62. PostgreSQL resolve localhost to an IPv6 address, and access was not enabled in pg_hba.conf for IPv6.
-
解决办法
Please go to your etc/hosts file and uncomment the following line:uncommented "127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4".
Check the file pg_hba.conf on the client that access is enabled for both IPv4 and IPv6 connections
Example:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust# IPv6 local connections:
host all all ::1/128 ident
Note for IPv6 you could change from ident to trust. It is the least secure of the authentication schemes and is seldom reasonable to use other than those from localhost. -
其他信息
1. When you connect to the database via psql, you are by default using a unix domain socket connection - so the line starting with "local" applies.
2. Find the logs location, it will be helpful in troubleshooting.
3. Once you locate the logs, try perform a login from NetVault again. Check the logs on which rule it is matching for this.4. Make sure you are editing the correct pg_hba.conf file, location may differeg./home/pgsql/data/var/lib/pgsql/data