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.
www.udemy.com/course/postgres...

[@plaintext7288]

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

[@zaidpatel4465]

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

[@ant-bytes]

Excellent demo clear concise and very informative

[@ramsiddu007]

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

[@freetrainingvideos]

Excellent demonstration! Thanks

[@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.

[@leomysky]

Thanks for such a concentrated information

[@codegist3048]

Amazing work my friend

[@ashishrao3069]

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

[@alisvo2766]

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

[@TheRahulkolan]

Very good explanation .

[@sandipkumarnandi]

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

[@evertonpila73]

The best!! Thanks for the explication

[@user-ep9zl9xl3x]

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 ?

[@ashokpatil4027]

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

[@ekonurmuhrodin1187]

amazing videos, Thanks very clear and helpfull

[@minhhieple6483]

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

[@eli1801]

two Spanish students owe you our database project score

[@medAmineRg]

great explanation thankyou

[@candycrushteamplayers4649]

so please for a big company wich architecture is the best

[@muhammadriansyahtohamba3062]

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

[@user-pm8yq1vg7y]

So Helpful 👍

[@mikhatanu]

Can you write to replica in this setup? Will it show on primary?

[@maheshshetty4088]

hi can you share the slides used.

[@AP-eh6gr]

slide at 3:14 is super important

[@nachoci6876]

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

[@kiranpatil2596]

Please one video postgres replication with master and docker slave container asynchronously

[@durgaprasadpj]

without restarting master server shall i able to scale the multiple slaves...?

[@dataxorg4359]

gr8 tutorial , and what is archive_moce, archive_command, restore_command etcc........

[@denmarkgarcia5153]

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

[@Bhupindersingh-qt1fh]

I am not able to create clusters with different ports and initdb is not working as well. Help me If possible. Thanks

[@arunreji4950]

How to do it in two laptops connected to same wifi?

[@ericgestopa6420]

does this replication works in version 10, too?

[@rafael0s782]

which postgres version did you use?

[@user-jf8qi2es4z]

I have the same question

[@小鳥ちゃん]

14.1?

[@amritbehera2523]

Kindly clarify the version of "Postgresql" ,for which this explanation applies.

[@TheHeartOfTheEvil]

14.1, you can see it written in the logs

[@amartuvshinbadnainymbuu4674]

is it working postgresql 10 version

[@ashutoshgamingboy3683]

bro, i am trying this on the windows.
psql postgres --port=5435
while connecting it is asking me for the password which i have not even passed.

[@Hemanthkumar-ic1fu]

how to do on windows sir

[@Delicatamente]

huge thanks!