✳flâneur — a map of the web's best reading

Ingest data from PostgreSQL CDC - RisingWave

docs.risingwave.com · 2,766 words · saved by 1 readers

Change Data Capture (CDC) refers to the process of identifying and capturing data changes in a database, and then delivering the changes to a downstream service in real time. RisingWave supports ingesting CDC data from PostgreSQL. Versions 10, 11, 12, 13, 14, 15, and 16 of PostgreSQL are supported. You can ingest CDC data from PostgreSQL into RisingWave in two ways: By default, it is replica. For CDC, you will need to set it to logical in the database configuration file (postgresql.conf) or via a psql command. The following command will change the wal_level. Keep in mind that changing the wal_level requires a restart of the PostgreSQL instance and can affect database performance. NOTE If you choose to create multiple CDC tables without using a shared source, be sure to set max_wal_senders to be greater than or equal to the number of synced tables. By default, max_wal_senders is 10. You can use the following statement to check the privileges of the user to the tables: An example result:

PostgreSQL CDC - RisingWave Documentation Index Fetch the complete documentation index at: /llms.txt Use this file to discover all available pages before exploring further. Skip to main content Need help generating SQL? Use Claude Code or Cursor with the RisingWave MCP server to generate and run SQL interactively. This guide explains how to connect RisingWave to a PostgreSQL database to ingest data changes in real time using the native PostgreSQL CDC source connector. RisingWave’s PostgreSQL CDC connector is compatible with any PostgreSQL-compliant database that supports logical replication, a

Explore this link on the map →

saved by

related reading