PostgreSQL Streaming Replication Tutorial

[@plaintext7288]

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

[@brumadodev]

The same here!!!

[@zaidpatel4465]

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

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

[@Bujde69]

Nice, now I know what I need to do if I want to replicate my data so that if my device fails, I have two databases down instead of just one and I'm back to square one but with extra steps.

[@ramsiddu007]

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

[@ant-bytes]

Excellent demo clear concise and very informative

[@AP-eh6gr]

slide at 3:14 is super important

[@eli1801]

two Spanish students owe you our database project score

[@muhammadriansyahtohamba3062]

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

[@codegist3048]

Amazing work my friend

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

[@nachoci6876]

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

[@jeetchheda8916]

1) How to specify a different remote server path to pg_basebackup ? 2) Can we pre-configure a Replication user but start the streaming a few years later after the production environment feels the need to start some replicas ?

[@Bhupindersingh-qt1fh]

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

[@ericgestopa6420]

does this replication works in version 10, too?

[@BrayanFlores-j7w]

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 ?

[@leomysky]

Thanks for such a concentrated information

[@arunreji4950]

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

[@rafael0s782]

which postgres version did you use?

[@Видеокартаб]

I have the same question

[@小鳥ちゃん]

14.1?

[@durgaprasadpj]

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

[@ashishrao3069]

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

[@mikhatanu]

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

[@ashutos122]

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]

is it working postgresql 10 version

[@ameenfarook-i7e]

Could you please create a video on bidirectional replication in postgressql

[@freetrainingvideos]

Excellent demonstration! Thanks

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

[@candycrushteamplayers4649]

so please for a big company wich architecture is the best

[@maheshshetty4088]

hi can you share the slides used.

[@denmarkgarcia5153]

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

[@ashokpatil4027]

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

[@minhhieple6483]

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

[@dataxorg4359]

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

[@evertonpila73]

The best!! Thanks for the explication

[@amritbehera2523]

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

[@TheHeartOfTheEvil]

14.1, you can see it written in the logs

[@ekonurmuhrodin1187]

amazing videos, Thanks very clear and helpfull

[@medAmineRg]

great explanation thankyou

[@kiranpatil2596]

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

[@kanakalakshmiMurikipudi]

So Helpful 👍

[@Hemanthkumar-ic1fu]

how to do on windows sir

[@NguyenHoang-nz5sc]

Thank u so much!

[@navarrodba]

Thanks!

[@Delicatamente]

huge thanks!