PostgreSQL Logical Replication Guide

  Рет қаралды 37,708

High-Performance Programming

High-Performance Programming

Күн бұрын

0:00 - Content of this video
0:22 - What is Logical Replication in Postgres?
5:54 - Step by step Logical Replication setup
Setting up the servers for Logical Replication
10:38 - Selective Copy of the Data
13:53 - Create the Publication
14:41 - Create the Subscription
17:43 - Postgres Limitations of Logical Replication
20:06 - Monitoring Logical Replication
23:16 - Best use-cases
🐘 Want to find out MORE about Scaling PostgreSQL?
Use the link below to get 60% OFF on the Entire Course.
www.udemy.com/course/postgres...

Пікірлер: 27
@scottspitlerII
@scottspitlerII 5 ай бұрын
God you made such a good video! Seriously no one has put anything as good as this up!
@mrmik82
@mrmik82 3 ай бұрын
That is true! Theo best tutoriale what I've ever seen. Thank you.
@habbex
@habbex 2 жыл бұрын
Thank you for the great explanation on the topic of logical replication, keep up the good work!
@agoodmuffin9905
@agoodmuffin9905 2 жыл бұрын
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
@clouddeep3687
@clouddeep3687 2 жыл бұрын
Very nice and clear guide, thank you.
@artemiypyatakov5438
@artemiypyatakov5438 Жыл бұрын
You are so good in a teaching. Please keep going.
@kalyaninagul8678
@kalyaninagul8678 5 ай бұрын
Thank you so much for this video. Very detailed and with good examples.
@radhikaganesan
@radhikaganesan Жыл бұрын
Great explanation!
@DanutSoare
@DanutSoare Жыл бұрын
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.
@decipheringthematrix56
@decipheringthematrix56 2 жыл бұрын
Great content
@seetharamavadhanam3462
@seetharamavadhanam3462 Жыл бұрын
Thank you very much. great video
@veerareddy6723
@veerareddy6723 2 жыл бұрын
Very good explanation. If possible please provide upgrade using logical replication. How to ignore Deletes or update in logical replication.
@gabrielosorio4908
@gabrielosorio4908 2 ай бұрын
This is amazing content, thank you very much, won another subscriber
@anton-r
@anton-r Жыл бұрын
so match senk you , great explanation for docker users that using psql 11 wal lvl -> command: - "postgres" - "-c" - "wal_level=logical"
@martindominikus8825
@martindominikus8825 2 жыл бұрын
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?
@adib-enc
@adib-enc 3 ай бұрын
Good content, thank you very much
@utkarshshukla4505
@utkarshshukla4505 11 ай бұрын
Nice explanation sir , can you please make video on BDR (Bi directional replication)
@MarkJones
@MarkJones 4 ай бұрын
DDL statements seem to flow thru on PGv14. At least our replica has changes that were made to the schema from our prod db.
@AuthorReviews
@AuthorReviews 2 жыл бұрын
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.
@davidzeng3807
@davidzeng3807 2 ай бұрын
pg_ctl: could not open PID file "/tmp/publication_db/postmaster.pid": Permission denied i changing owner to postgres already but still have errors
@ravulapallivenkat8640
@ravulapallivenkat8640 Жыл бұрын
Hi everything is good but iam not able to get replicated the tables which are generated from11 to 20 please provide answer for this error.
@utkarshshukla2448
@utkarshshukla2448 11 ай бұрын
sir please make video on BDR replicational also
@tuoikien602
@tuoikien602 7 ай бұрын
Can this logical replication use for other databases like mongodb?
@hinhnguyeninh7610
@hinhnguyeninh7610 2 жыл бұрын
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.
@ander172
@ander172 Жыл бұрын
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 ?
@seamusmcdonald6310
@seamusmcdonald6310 Жыл бұрын
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.
@user-qe9su7tj1m
@user-qe9su7tj1m 6 ай бұрын
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
PostgreSQL Streaming Replication Tutorial
15:54
High-Performance Programming
Рет қаралды 61 М.
PostgreSQL HA High Availability Tutorial
19:04
High-Performance Programming
Рет қаралды 45 М.
Amazing weight loss transformation !! 😱😱
00:24
Tibo InShape
Рет қаралды 67 МЛН
小蚂蚁被感动了!火影忍者 #佐助 #家庭
00:54
火影忍者一家
Рет қаралды 41 МЛН
哈莉奎因以为小丑不爱她了#joker #cosplay #Harriet Quinn
00:22
佐助与鸣人
Рет қаралды 9 МЛН
I've been using Redis wrong this whole time...
20:53
Dreams of Code
Рет қаралды 348 М.
Pgpool-II Tutorial
32:30
High-Performance Programming
Рет қаралды 54 М.
Which Database Model to Choose?
24:38
High-Performance Programming
Рет қаралды 49 М.
Wait... PostgreSQL can do WHAT?
20:33
The Art Of The Terminal
Рет қаралды 191 М.
Solving one of PostgreSQL's biggest weaknesses.
17:12
Dreams of Code
Рет қаралды 187 М.
Logical Replication with PostgreSQL 10
13:43
PostgresCourse.com
Рет қаралды 33 М.
Сколько реально стоит ПК Величайшего?
0:37
Todos os modelos de smartphone
0:20
Spider Slack
Рет қаралды 66 МЛН
ноутбуки от 7.900 в тг laptopshoptop
0:14
Ноутбуковая лавка
Рет қаралды 3,6 МЛН
$1 vs $100,000 Slow Motion Camera!
0:44
Hafu Go
Рет қаралды 29 МЛН