You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pulsar.apache.org by GitBox <gi...@apache.org> on 2021/08/05 10:50:30 UTC
[GitHub] [pulsar] picassoo opened a new issue #11568: Pulsar Sink Localrun - Not able to find table - PostgreSQL
picassoo opened a new issue #11568:
URL: https://github.com/apache/pulsar/issues/11568
**Sink Connectors can not find table**
Hi,
I tried Pulsar IO features (source and sink connectors) in standalone mode. Source connectors works very well with debezium connector. But Sink Connector can find table while deploying jdbc postgresql connector. Naturally , Pulsar can not write topic message to table.
Sink Config YAML File:
```
tenant: "public"
namespace: "default"
name: "postgresql-storage-sink"
archive: "connectors/pulsar-io-jdbc-postgres-2.8.0.nar"
parallelism: 1
inputs:
- "user-avro-topic"
configs:
userName: "stream"
password: "password"
jdbcUrl: `"jdbc:postgresql://postgreshost:5432/postgres?currentSchema=public"`
tableName: "pulsarsink"
```
**Possible Solution**
I suspect jdbcUrl can be wrong. I excanged host, database ans schema sequentially. When I did these, Pulsar throws connection exception.
Eventually, problem is not caused from jdbcUrl. But I never seen any example on pulsar site demostrate sink connector with database schema info.
Can you give any example that accomplish to connect postgresql with db schema info.
Pulsar version 2.8.0
Docker version 20.10.7
postgres (PostgreSQL) 13.3
**Pictures**
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@pulsar.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [pulsar] codelipenghui commented on issue #11568: Pulsar Sink Localrun - Not able to find table - PostgreSQL
Posted by GitBox <gi...@apache.org>.
codelipenghui commented on issue #11568:
URL: https://github.com/apache/pulsar/issues/11568#issuecomment-1058887331
The issue had no activity for 30 days, mark with Stale label.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@pulsar.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org