Failed to initialize database, got error failed to connect to `host=xxxxx user=xxxxx database=postgres`

[ivannguyendev]

When trying to connect to PostgreSQL cloud, encountering authentication error:

[error] failed to initialize database, got error failed to connect to 
`host=xxxxx user=xxxxx database=postgres`: server error 
(FATAL: no pg_hba.conf entry for host "xxxxxx", user "xxxxx", database "postgres", no encryption (SQLSTATE 28000))

Configuration

environment configuration in dify-plugin.yaml:

- name: DB_USERNAME
  valueFrom:
    secretKeyRef:
      name: postgres-credentials
      key: pg-username
- name: DB_PASSWORD
  valueFrom:
    secretKeyRef:
      name: postgres-credentials
      key: pg-password
- name: DB_HOST
  valueFrom:
    secretKeyRef:
      name: postgres-credentials
      key: pg-host
- name: DB_PORT
  valueFrom:
    secretKeyRef:
      name: postgres-credentials
      key: pg-port
- name: DB_DATABASE
  value: dify-plugin
- name: SQLALCHEMY_POOL_SIZE
  value: '20'
- name: DB_PLUGIN_DATABASE
  value: dify-plugin

i find a hardcoded 'postgres' database name here: https://github.com/langgenius/dify-plugin-daemon/blob/main/internal/db/init.go

[Foglotus]

When trying to connect to PostgreSQL cloud, encountering authentication error:

[error] failed to initialize database, got error failed to connect to 
`host=xxxxx user=xxxxx database=postgres`: server error 
(FATAL: no pg_hba.conf entry for host "xxxxxx", user "xxxxx", database "postgres", no encryption (SQLSTATE 28000))

Configuration

environment configuration in dify-plugin.yaml:

• name: DB_USERNAME
  valueFrom:
  secretKeyRef:
  name: postgres-credentials
  key: pg-username
• name: DB_PASSWORD
  valueFrom:
  secretKeyRef:
  name: postgres-credentials
  key: pg-password
• name: DB_HOST
  valueFrom:
  secretKeyRef:
  name: postgres-credentials
  key: pg-host
• name: DB_PORT
  valueFrom:
  secretKeyRef:
  name: postgres-credentials
  key: pg-port
• name: DB_DATABASE
  value: dify-plugin
• name: SQLALCHEMY_POOL_SIZE
  value: '20'
• name: DB_PLUGIN_DATABASE
  value: dify-plugin
  i find a hardcoded 'postgres' database name here: https://github.com/langgenius/dify-plugin-daemon/blob/main/internal/db/init.go

这个问题可能是因为中间件启动顺序问题，在db还未成功启动的时候，这个服务启动了，临时解决方案是，你可以单独重新restart一下这个容器，这样就能在开始的时候连上db了