您好,我正在使用Jitterbit集成服务将PostgreSQL与salesforce集成。我的windows 7机器上安装了Jitterbit Studio和Jitterbit代理。
Click this link to see screenshot of the error message in my jitterbit Studio
我试图在Jitterbit studio中添加PostgreSQL源代码,但出现错误:
Failed to connect to database. FATAL: password authentication failed for user "postgres" (SqlState: 28P01).
Studio version: 8.24.2.2
Studio platform: Windows 7 - Java 1.8.0_121
Cloud: https://emea-west.jitterbit.com
User:[email protected]
Org: Demo [ID = 214458]
Environment: Default Environment [ID = 227118]
Agent Group: Jitterbit Cloud Agent Group [ID = 1542] [Lowest Agent Version = 8.24.1.1]
Project: New Project [GUID = dff2e842-3752-4f19-99cf-3a96c675c18a]
Timestamp: 2017-06-30 14:11:08.121
PostgreSQL的用户名和密码分别是“postgres”和“root”,但仍然有错误。
最佳答案
打开PostgreSQL文件夹中的pg_hba.conf.sample文件。
将下面的行添加到文件的现有内容:
host all all trust