PostgreSQL Streaming Replication Tutorial

0:00 - What is Streaming Replication?
2:12 - Asynchronous vs. Synchronous Replication
4:45 - Hands-on - Initialise Primary Database
6:14 - Configuring the Primary for Replication
10:01 - Configuring the Replica Instance
13:01 - Testing Replication Setup

🐘 Want to find out MORE about Scaling PostgreSQL?
Use the link below to get 60% OFF on the Entire Course.

[plaintext]

Spent ~5 hours reading the docs and still couldn't set up replication, while you can teach it in under 20 minutes!
Amazing!

[zaidpatel]

Crystal clear explanation dude !!!
Keep it up, keep the content coming you are doing great !!!

[eli]

two Spanish students owe you our database project score

[ramsiddu]

Very Informative and Clear Explanation, thank you for sharing this.

[ashishrao]

Please keep them postgres videos coming. Subscribed and shared your channel across my peers. Cannot wait for more content

[ant-bytes]

Excellent demo clear concise and very informative

[alisvo]

wal_keep_size and max_slot_wal_keep_size must be configured in order to prevent possible replication fails (Network failure, system crash etc.)

[biagiola]

I have postgres, one of the last, but I dont have installed the initdb tool, neither in my ubuntu and debian system by default. And I read that we dont need that really btw I like your channel and your vids. Very concise and straightforward.

[denmarkgarcia]

Isn't dangerous to put the config in /tmp? Linux must automatically wipe it off? Anyway nice explanation 😊

[epzlxlx]

Excellent turorial. I've been reading some similar tutorials and some of them uses Docker instead of initdb. Is there an adavantage using Docker ? Is possible to create replica instances without using initdb ?

[ameenfarook-ie]

Could you please create a video on bidirectional replication in postgressql

[leomysky]

Thanks for such a concentrated information

[ashokpatil]

Very nicely explained.. clear voice.. it seems it is for Linux.. is same available for windows?

[dataxorg]

gr8 tutorial, and what is archive_moce, archive_command, restore_command

[muhammadriansyahtohamba]

thanks

what if I want to do replication in a different server IP ?

[sandipkumarnandi]

wonderful video, could you please make a video on configuring the same on two different servers, it would be of great help.

[ekonurmuhrodin]

amazing videos, Thanks very clear and helpfull

[ericgestopa]

does this replication works in version 10, too?

[minhhieple]

Can you clarify the difference between streaming replication and logical replication ?

[nachoci]

Dont you have to change the data files owner in the replica?