Intellij Idea Intellij未连接到Postgres

cgh8pdjw  于 2023-05-16  发布在  其他
关注(0)|答案(1)|浏览(192)

我可以使用pgadmin 4连接到postgres。我无法使用Intellij连接。我从Intellij得到的消息:[28P01] FATAL: password authentication failed for user "admin"
Intellij正在尝试连接到数据库,但结束时显示:2023-05-14 07:03:46,333 [1806050] INFO - #c.i.e.r.RemoteProcessSupport - Process finished with exit code -1
Intellij的数据库插件已更新。注意:我可以通过Intellij连接到MySQL。
相关Postgres服务器配置:

ALLOW_SAVE_PASSWORD = True
ALLOW_SAVE_TUNNEL_PASSWORD = False
APP_COPYRIGHT = "Copyright (C) 2013 - 2023, The pgAdmin Development Team"
APP_ICON = "pg-icon"
APP_NAME = "pgAdmin 4"
APP_RELEASE = 7
APP_REVISION = 1
APP_SUFFIX = ""
APP_VERSION = "7.1"
APP_VERSION_INT = 70100
AUTHENTICATION_SOURCES = ['internal']
AUTO_DISCOVER_SERVERS = True
DEFAULT_SERVER = "127.0.0.1"
DEFAULT_SERVER_PORT = 5050
DESKTOP_USER = "pgadmin4@pgadmin.org"
EFFECTIVE_SERVER_PORT = 55627

我注意到Intellij的主机属性设置为端口5432,而DEFAULT_SERVER_PORT = 5050。更改端口没有帮助。我还进入了pg_hba的conf文件,并将方法从scram-sha-256改为md5,但没有效果。

p1iqtdky

p1iqtdky1#

我在本地运行pgadmin4的独立版本。当我在docker容器中运行pgadmin和postgres时,我能够连接没有问题。

相关问题