Very good content. The video is well structured, illustrations are straightforward & pleasant to look at, and you are speaking very clearly. Keep it up +1
Hi. Very good presentation of logical replication! One thing I want to mention is that schema is not the same as the database. In this case, the schema used was Public and the database name was Pub.
Thanks for the video. But I'm facing some issues. First of all I'm running both servers in Docker containers. I use Dbeaver to connect to database and manage it. When i create Database everything works fine. Once I change postgresql.conf file and restart postgres in container I can't connect to it using Dbeaver, although I can manage database in docker container. Another issue is with dumping and restoring at the same time - never works like in your video. I don;t know what am I doing wrong. Coudn't find any solution.
Ok, and what if subscriber has outage - not connected some time...( Hours,days...) And then connected back, how will be then sql data replicated in what order ?
I believe you will need to reinitialize the stream with the last processed LSN (log sequence number) which can be stored in a shared, persistent state. If you have more than one consumer, more logic and data will be required.
Great video! By the way, is there a way to store the replication log? I need to know the timestamp when the DML operation occurs, or if I can write a code that pull the timestamp and store it back to the table, is there a way to see these logs stream?
I got an error could not connect to the publisher: connection to server at "ip host", port 5432 failed: fe_sendauth: no password supplied , How should I deal with it, help me, please.
I will like to talk to you, I really like your lectures on Postgres. Please send me your email address, I will like to talk about my interest of becoming DBA