Support for Postgresql table engine
As a developer with a current PostgreSQL instance,
I would like to utilise the ClickHouse PostgreSQL Table engine,
so that I can easily read from that external PostgreSQL instance and insert the data into my Aiven for ClickHouse instance.
AdminJohn Joseph Kennedy
(Head of Databases, Aiven.io)
shared this idea
-
Reviewing this request, currently there is a method for setting up a PostgreSQL instance, external to Aiven, as an integration endpoint.
Once you have set this up at the account level (first image), any of the services running in that account, including Aiven for ClickHouse, can set this up as an integration.
Simply go to the specific service, and click on the "Get Started" button (second eimage), and in the following menu filter for PostgreSQL, and select the endpoint you previously set up.
(Edited by admin) -
Miguel
commented
A match made in heaven
https://clickhouse.com/blog/migrating-data-between-clickhouse-postgres
