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.

Answer 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