Real-Time Change Data Capture with PostgreSQL

preview_player
Показать описание
In this tutorial, you'll learn how to set up PostgreSQL Change Data Capture in minutes using Airbyte, leveraging a powerful tool like Debezium to build a near real-time EL(T)

Рекомендации по теме
Комментарии
Автор

Recently i discovered you channels, you inspire me to keep going in the full stack developer long run. Regards from Cuba

josefleitas
Автор

Great tutorial for a stand alone but it would be nice to see a tutorial for postgres cluster. I’m running into issues where replication slot gets lost when the primary server is down.

shakiz
Автор

This is very very informative. Is it possible to replicate data from one database to another (like postgres to postgres)?

codecamp
Автор

Hi! Whats the slack that you mentioned? I also wanted to ask if this real time replication is resilient to DDL changes from the source.

AWS Dms is not, and has been causing issues anytime our source DB has any ddl changes

mastershefu
Автор

#Airbyte thanks a lot, i tried but unable to connect the PostgresSQL from connector, where as i am able to connect from pgAgent ...error -X POST -H "Accept:application/json" -H localhost:8083/connectors/ -d @cdc_deb.json
{"error_code":400, "message":"Connector configuration is invalid and contains the following 1 error(s):\nError while validating connector config: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.\nYou can also find the above list of errors at the endpoint

SpiritOfIndiaaa
Автор

#Airbyte thanks a lot, i tried but unable to connect the PostgresSQL from connector, where as i am able to connect from pgAgent ...error -X POST -H "Accept:application/json" -H localhost:8083/connectors/ -d @cdc_deb.json
{"error_code":400, "message":"Connector configuration is invalid and contains the following 1 error(s):\nError while validating connector config: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.\nYou can also find the above list of errors at the endpoint

SpiritOfIndiaaa