美文网首页
The authentication type 10 is no

The authentication type 10 is no

作者: 惜小八 | 来源:发表于2022-05-09 15:55 被阅读0次

    连接PG数据库报错

    org.postgresql.util.PSQLException: The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver.

    修改pg_hba.conf配置文件当中的ipv4如下

    # TYPE  DATABASE        USER            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
    host    all             all             0.0.0.0/0               trust
    # IP6 local connections:
    host    all             all             ::1/128                 trust
    # Allow replication connections from localhost, by a user with the
    # replication privilege.
    local   replication     all                                     trust
    host    replication     all             127.0.0.1/32            trust
    host    replication     all             ::1/128                 trust
    
    host all all all scram-sha-256
    
    

    或者采用如下的方式:

    解决方法将pg_hba.conf由"host all all all scram-sha-256"改"host all all all trust"
    ····

    相关文章

      网友评论

          本文标题:The authentication type 10 is no

          本文链接:https://www.haomeiwen.com/subject/xoilurtx.html