Replication data from Postgresql to ClickHouse #34580
zkuser2002
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I want to replicate data from postgresql to clickhouse,
I use MatrerializedPostgresql
At first I create postgresql database with this code
Create database postgresql_db_name
ENGINE=MaterializedPostgresql (host:port,postgresql_dbname,user,pass)
2- create a clickhouse_db_name
That is blank
3- Right know when I want to replicate data from postgresql to clickhouse I use
create table clickhouse-db_name.tblname as postgresql_db_name.tblname
ENGINE=MergeTree()
PRIMARY KEY ()
4- In the output I see that
ostgresql_db_name.tblname don't exist
Do you know how can I solve it?
I think when I create db with MaterializedPostgresql I can get all table in one query
And also for schema
Beta Was this translation helpful? Give feedback.
All reactions