java连接PostgreSql数据库抛出org.postgresql.util.PSQLEx...

2019独角兽企业重金招聘Python工程师标准>>>

这是因为PostgreSql数据库默认是用MD5加密的密码连接的。

在PostgreSql的安装目录下的data文件夹里找到pg_hba.conf文件，会看到下面的代码

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5

把md5改成trust。

上面的注释有写到：

# METHOD can be "trust", "reject", "md5", "password", "gss", "sspi",
# "krb5", "ident", "peer", "pam", "ldap", "radius" or "cert".  Note that
# "password" sends passwords in clear text; "md5" is preferred since
# it sends encrypted passwords.

转载于:https://my.oschina.net/skyhacker2/blog/119884