PostgreSQL Logical Replication Guide

  Рет қаралды 36,253

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 3 ай бұрын
God you made such a good video! Seriously no one has put anything as good as this up!
@mrmik82
@mrmik82 2 ай бұрын
That is true! Theo best tutoriale what I've ever seen. Thank you.
@habbex
@habbex Жыл бұрын
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
@gabrielosorio4908
@gabrielosorio4908 Ай бұрын
This is amazing content, thank you very much, won another subscriber
@artemiypyatakov5438
@artemiypyatakov5438 11 ай бұрын
You are so good in a teaching. Please keep going.
@clouddeep3687
@clouddeep3687 2 жыл бұрын
Very nice and clear guide, thank you.
@kalyaninagul8678
@kalyaninagul8678 4 ай бұрын
Thank you so much for this video. Very detailed and with good examples.
@radhikaganesan
@radhikaganesan Жыл бұрын
Great explanation!
@seetharamavadhanam3462
@seetharamavadhanam3462 Жыл бұрын
Thank you very much. great video
@martindominikus8825
@martindominikus8825 Жыл бұрын
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 2 ай бұрын
Good content, thank you very much
@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
@veerareddy6723
@veerareddy6723 2 жыл бұрын
Very good explanation. If possible please provide upgrade using logical replication. How to ignore Deletes or update in logical replication.
@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"
@utkarshshukla4505
@utkarshshukla4505 10 ай бұрын
Nice explanation sir , can you please make video on BDR (Bi directional replication)
@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.
@utkarshshukla2448
@utkarshshukla2448 10 ай бұрын
sir please make video on BDR replicational also
@MarkJones
@MarkJones 3 ай бұрын
DDL statements seem to flow thru on PGv14. At least our replica has changes that were made to the schema from our prod db.
@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.
@tuoikien602
@tuoikien602 6 ай бұрын
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.
@davidzeng3807
@davidzeng3807 Ай бұрын
pg_ctl: could not open PID file "/tmp/publication_db/postmaster.pid": Permission denied i changing owner to postgres already but still have errors
@user-qe9su7tj1m
@user-qe9su7tj1m 5 ай бұрын
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
Рет қаралды 58 М.
PostgreSQL HA High Availability Tutorial
19:04
High-Performance Programming
Рет қаралды 43 М.
Nutella bro sis family Challenge 😋
00:31
Mr. Clabik
Рет қаралды 9 МЛН
Я нашел кто меня пранкует!
00:51
Аришнев
Рет қаралды 3,5 МЛН
ОДИН ДЕНЬ ИЗ ДЕТСТВА❤️ #shorts
00:59
BATEK_OFFICIAL
Рет қаралды 8 МЛН
100+ Linux Things you Need to Know
12:23
Fireship
Рет қаралды 111 М.
Logical Replication in PostgreSQL
48:54
CloudBhai
Рет қаралды 3,7 М.
Pgpool-II Tutorial
32:30
High-Performance Programming
Рет қаралды 52 М.
Logical replication | Postgres.FM 063 | #PostgreSQL #Postgres podcast
46:01
PostgresTV 💙💛
Рет қаралды 1 М.
Logical Replication in PostgreSQL
54:32
EDB
Рет қаралды 9 М.
Опыт использования Мини ПК от TECNO
1:00
Андронет
Рет қаралды 221 М.
Хотела заскамить на Айфон!😱📱(@gertieinar)
0:21
Взрывная История
Рет қаралды 5 МЛН
Неразрушаемый смартфон
1:00
Status
Рет қаралды 2,3 МЛН