PostgreSQL Streaming Replication Tutorial

Рет қаралды 59,445

Күн бұрын

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

Пікірлер: 42

@plaintext7288 11 ай бұрын

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

@zaidpatel4465 2 жыл бұрын

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

@ant-bytes 2 жыл бұрын

Excellent demo clear concise and very informative

@ramsiddu007 2 жыл бұрын

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

@freetrainingvideos 8 ай бұрын

Excellent demonstration! Thanks

@leomysky Жыл бұрын

Thanks for such a concentrated information

@biagiola 2 жыл бұрын

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.

@codegist3048 8 ай бұрын

Amazing work my friend

@TheRahulkolan Жыл бұрын

Very good explanation .

@evertonpila73 Жыл бұрын

The best!! Thanks for the explication

@medAmineRg 4 ай бұрын

great explanation thankyou

@ekonurmuhrodin1187 Ай бұрын

amazing videos, Thanks very clear and helpfull

@user-pm8yq1vg7y 5 ай бұрын

So Helpful 👍

@sandipkumarnandi Жыл бұрын

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

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

@eli1801 Ай бұрын

two Spanish students owe you our database project score

@ashishrao3069 Жыл бұрын

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

@ashokpatil4027 Жыл бұрын

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

@user-ep9zl9xl3x 4 ай бұрын

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 ?

@AP-eh6gr 4 ай бұрын

slide at 3:14 is super important

@minhhieple6483 Жыл бұрын

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

@candycrushteamplayers4649 Жыл бұрын

so please for a big company wich architecture is the best

@denmarkgarcia5153 8 ай бұрын

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

@muhammadriansyahtohamba3062 Жыл бұрын

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

@mikhatanu 11 ай бұрын

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

@nachoci6876 6 ай бұрын

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

@rafael0s782 Жыл бұрын

which postgres version did you use?

@user-jf8qi2es4z Жыл бұрын

I have the same question

@小鳥ちゃん 8 ай бұрын

14.1?

@kiranpatil2596 Жыл бұрын

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

@durgaprasadpj 11 ай бұрын

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

@dataxorg4359 16 күн бұрын

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

@maheshshetty4088 2 жыл бұрын

hi can you share the slides used.

@ericgestopa6420 Ай бұрын

does this replication works in version 10, too?

@Bhupindersingh-qt1fh 8 ай бұрын

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

@Delicatamente 3 ай бұрын

huge thanks!

@arunreji4950 7 ай бұрын

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

@amritbehera2523 2 жыл бұрын

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

@TheHeartOfTheEvil 5 ай бұрын

14.1, you can see it written in the logs

@ashutoshgamingboy3683 6 ай бұрын

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.

@amartuvshinbadnainymbuu4674 6 ай бұрын

is it working postgresql 10 version

@Hemanthkumar-ic1fu Жыл бұрын

how to do on windows sir