How to set up a serverless Neon PostgreSQL database as a source for RisingWave.
To connect RisingWave to a Neon database for Change Data Capture (CDC), you first need to configure your Neon project.
If you haven’t already, sign up for a Neon account and create a project. This will provision a new serverless PostgreSQL database. Note your project’s connection details.
Connect to your Neon database using the provided SQL Editor or any compatible psql
client.
Run the following command to set the wal_level
to logical
, which is required for CDC.
Your Neon project may need to restart for this change to apply.
Create or alter a user, granting them the necessary roles for replication.
You can verify the roles by running \du
in psql
.
Finally, grant the user the necessary privileges on the database and schemas you want to capture changes from.
Now that your Neon database is configured, you can proceed to connect RisingWave.