Ingest data from PostgreSQL
PostgreSQL is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance.
Quick Start
Connect in minutes with SQL
Use CREATE SOURCE or CREATE TABLE to ingest data from PostgreSQL into RisingWave. No plugins, no middleware — just PostgreSQL-compatible SQL.
CREATE SOURCE pg_cdc_source WITH (
connector = 'postgres-cdc',
hostname = '127.0.0.1',
port = '8306',
username = 'root',
password = '123456',
database.name = 'mydb',
slot.name = 'mydb_slot'
);
CREATE TABLE orders_rw (
order_id INTEGER PRIMARY KEY,
customer_id INTEGER,
order_status VARCHAR,
total_amount DECIMAL,
last_updated TIMESTAMP,
)
FROM source pg_cdc_source TABLE orders;For comprehensive configuration details, please refer to the PostgreSQL connector documentation.
Capabilities
What you can do with RisingWave + PostgreSQL
Real-time Ingestion
Continuously stream data from PostgreSQL into RisingWave with sub-second latency. Process millions of events per second.
SQL Transformations
Join PostgreSQL data with other sources, apply windowing, aggregation, and filtering — all in standard SQL.
Materialized Views
Create incrementally maintained materialized views over PostgreSQL data. Always fresh, always queryable.
Multi-format Support
Supports Avro, JSON, Protobuf, CSV, and more. Compatible with Schema Registry for schema evolution.
Resources
Learn more
Complete configuration reference, authentication options, and advanced features for the PostgreSQL source connector.
RisingWave also supports PostgreSQL as a destination. View the destination connector.
Get RisingWave running locally in 5 minutes and try your first streaming pipeline.
Start streaming in minutes
Connect to PostgreSQL with just a few lines of SQL. No infrastructure to manage, no code to write.
