How to perform real-time Postgres to Redis sync?

Question

I want to sync a Postgres table (2 million records) to Redis.

Requirements:

Full table should sync initially
After that, realtime insert/update/delete should sync to Redis automatically (no polling)

I have tried:

pgsync → but got "no source issue"
Red Courier (Golang) → but private docker image, could not proceed

What is the best way to do this? I want something reliable and not too complex to maintain.

Yaron · Accepted Answer · 2025-06-24 09:01:33Z

1

Redis offers Redis Data Integration (RDI) for this. With RDI you can sync your Redis with the Postgres tables you want and transform the data to any Redis data type you want without coding.
We (Redis) created this product so that:

Applications can have a prefetched cache and provide their read queries super fast at scale
Developers and DevOps don't need to spend time integrating and coding CDC pipelines
- Declarative transformations & filters
- Denormalisation of data
- Supports different Redis data structures
Operators get all they need (helm charts / installers, monitoring, logs, secret store integration, day 2 operations via API and GUI) to operate this mission critical pipelines

edited Jun 24 at 9:01

answered Jun 23 at 13:17

Yaron

893 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to perform real-time Postgres to Redis sync?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related