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.
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.