We recently announced the Postgres CDC connector in ClickPipes, now available in Public Preview. This connector is fully powered by PeerDB.
As a ClickHouse Cloud customer, you get a seamless, native experience for moving data from your Postgres databases to ClickHouse Cloud. Simply navigate to the Data Sources tab and add a Postgres source to start ingesting data.
The Postgres ClickPipe is in Public Beta
This is a document on setting a Clickhouse Cloud peer for PeerDB.
If you are using ClickHouse Cloud, we recommend using PeerDB Cloud, which comes with free trial and highly competitive pricing and PeerDB Cloud is specifically designed for ClickHouse Cloud.
Head over the SQL Console in the ClickHouse Cloud UI.
Clickhouse Cloud SQL Console
If you are using PeerDB Cloud, you need to whitelist the PeerDB Cloud IPs in the ClickHouse Cloud settings tab.
Clickhouse Cloud SQL Console
You can find the IPs of your PeerDB instance here.
ClickHouse native protocol
which by default is 9440
for the secure TLS-enabled port and 9000
for the non-TLS port. If the default ports have been changed, please adjust them accordingly.We do not recommend using the non-TLS enabled port for ClickHouse. If this is needed, please also check the Disable TLS?
option when creating the Clickhouse peer (as seen below).
Create ClickHouse Peer
Name
, Host
, Port
(as determined above), User
, Password
and Database
.Validate
to ensure that the connection is successful.Create
to create the ClickHouse Peer.Here is a list of some validation errors that you might encounter and how to resolve them:
You may need to disable TLS
You may need to disable TLS. Validation errors such as the following may occur if the connection is not successful:
EOF
If you see the following error, it means that the connection to the ClickHouse peer could not be established:
Please try the following:
Stuck on Validating…
This means the port entered is incorrect. Please ensure that the port is correct and the ClickHouse server is reachable from the PeerDB server.
We recently announced the Postgres CDC connector in ClickPipes, now available in Public Preview. This connector is fully powered by PeerDB.
As a ClickHouse Cloud customer, you get a seamless, native experience for moving data from your Postgres databases to ClickHouse Cloud. Simply navigate to the Data Sources tab and add a Postgres source to start ingesting data.
The Postgres ClickPipe is in Public Beta
This is a document on setting a Clickhouse Cloud peer for PeerDB.
If you are using ClickHouse Cloud, we recommend using PeerDB Cloud, which comes with free trial and highly competitive pricing and PeerDB Cloud is specifically designed for ClickHouse Cloud.
Head over the SQL Console in the ClickHouse Cloud UI.
Clickhouse Cloud SQL Console
If you are using PeerDB Cloud, you need to whitelist the PeerDB Cloud IPs in the ClickHouse Cloud settings tab.
Clickhouse Cloud SQL Console
You can find the IPs of your PeerDB instance here.
ClickHouse native protocol
which by default is 9440
for the secure TLS-enabled port and 9000
for the non-TLS port. If the default ports have been changed, please adjust them accordingly.We do not recommend using the non-TLS enabled port for ClickHouse. If this is needed, please also check the Disable TLS?
option when creating the Clickhouse peer (as seen below).
Create ClickHouse Peer
Name
, Host
, Port
(as determined above), User
, Password
and Database
.Validate
to ensure that the connection is successful.Create
to create the ClickHouse Peer.Here is a list of some validation errors that you might encounter and how to resolve them:
You may need to disable TLS
You may need to disable TLS. Validation errors such as the following may occur if the connection is not successful:
EOF
If you see the following error, it means that the connection to the ClickHouse peer could not be established:
Please try the following:
Stuck on Validating…
This means the port entered is incorrect. Please ensure that the port is correct and the ClickHouse server is reachable from the PeerDB server.