Snowshoe logo
all-things-risingwave

How can I ingest data from PostgreSQL to RisingWave without maintaining a Kafka cluster?

Mike Spicer is looking for a way to ingest data from PostgreSQL to RisingWave without the need to maintain a Kafka cluster. Tao Wu provides information on how to achieve this through a native integration demo for Postgres CDC.

Mi

Mike Spicer

Asked on Jan 28, 2023

  • To ingest data from PostgreSQL to RisingWave without maintaining a Kafka cluster, you can use the native integration demo for Postgres CDC provided by RisingWave.

  • Start the cluster by running the following command:

docker compose up -d

  • This will start a Postgres and RisingWave with data prepared.

  • Input the SQL commands in create_source.sql, create_mv.sql, and query.sql to see the Postgres data being asynchronously extracted to RisingWave.

Jan 31, 2023Edited by