apache / flink-cdc

Flink CDC is a streaming data integration tool
https://nightlies.apache.org/flink/flink-cdc-docs-stable
Apache License 2.0
5.71k stars 1.94k forks source link

When postgres cdc get exception 'FATAL: no pg_hba.conf' but work normally in jdbc connector. #1545

Closed lpn666 closed 2 years ago

lpn666 commented 2 years ago

Describe the bug(Please use English) A clear and concise description of what the bug is.

Environment :

To Reproduce Steps to reproduce the behavior:

  1. The test data :
  2. The test code :

CREATE TABLE eee ( a string , b string ) WITH ( 'connector' = 'postgres-cdc', 'hostname' = 'localhost', 'port' = '5432', 'username' = 'postgres', 'password' = 'postgres', 'database-name' = 'test', 'schema-name' = 'public', 'table-name' = 'flink01' );

select * from eee;

  1. The error : image

Additional Description When I use jdbc connector or spring jdbc to connect the database, it's running normally.

I have try to alter the pg_hba.conf file. but it's not work. image

jcunhafonte commented 4 months ago

@lpn666 Were you able to fix this issue?