Skip to main content

Replicate data from PostgreSQL to Redshift

In this guide, we are going to create a real-time data pipeline to sync data from PostgreSQL to Redshift using Meroxa. This pipeline will keep a table within Redshift up-to-date with every insert, update, and delete operation from PostgreSQL.

Postgres to Redshift

How to Expose PostgreSQL Remotely Using ngrok

In this guide, we will walk through exposing a local PostgreSQL instance with ngrok. This method allows you to quickly test and analyze the behavior of PostgreSQL with data platforms like Meroxa.

Add Local PG

For this example, we are going to use ngrok. ngrok exposes local servers behind NATs and firewalls to the public internet over secure tunnels.