PostgreSQL Streaming Replication Tutorial

Sdílet
Vložit
  • čas přidán 22. 08. 2024

Komentáře • 44

  • @plaintext7288
    @plaintext7288 Před rokem +6

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

  • @zaidpatel4465
    @zaidpatel4465 Před 2 lety +8

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

  • @eli1801
    @eli1801 Před 3 měsíci +1

    two Spanish students owe you our database project score

  • @ashishrao3069
    @ashishrao3069 Před rokem

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

  • @ramsiddu007
    @ramsiddu007 Před 2 lety +2

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

  • @AP-eh6gr
    @AP-eh6gr Před 5 měsíci +2

    slide at 3:14 is super important

  • @alisvo2766
    @alisvo2766 Před 2 lety +3

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

  • @freetrainingvideos
    @freetrainingvideos Před 10 měsíci +1

    Excellent demonstration! Thanks

  • @ant-bytes
    @ant-bytes Před 2 lety +1

    Excellent demo clear concise and very informative

  • @biagiola
    @biagiola Před 2 lety

    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
    @codegist3048 Před 9 měsíci +1

    Amazing work my friend

  • @leomysky
    @leomysky Před rokem

    Thanks for such a concentrated information

  • @denmarkgarcia5153
    @denmarkgarcia5153 Před 9 měsíci +1

    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 ?

  • @TheRahulkolan
    @TheRahulkolan Před rokem

    Very good explanation .

  • @ekonurmuhrodin1187
    @ekonurmuhrodin1187 Před 3 měsíci

    amazing videos, Thanks very clear and helpfull

  • @navarrodba
    @navarrodba Před 3 dny

    Thanks!

  • @user-ep9zl9xl3x
    @user-ep9zl9xl3x Před 5 měsíci

    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-i7e
    @ameenfarook-i7e Před měsícem

    Could you please create a video on bidirectional replication in postgressql

  • @evertonpila73
    @evertonpila73 Před rokem

    The best!! Thanks for the explication

  • @rafael0s782
    @rafael0s782 Před rokem +3

    which postgres version did you use?

  • @sandipkumarnandi
    @sandipkumarnandi Před rokem

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

  • @ashokpatil4027
    @ashokpatil4027 Před rokem

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

  • @medAmineRg
    @medAmineRg Před 6 měsíci

    great explanation thankyou

  • @Bhupindersingh-qt1fh
    @Bhupindersingh-qt1fh Před 9 měsíci

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

  • @arunreji4950
    @arunreji4950 Před 8 měsíci

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

  • @amritbehera2523
    @amritbehera2523 Před 2 lety +1

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

  • @dataxorg4359
    @dataxorg4359 Před měsícem

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

  • @ericgestopa6420
    @ericgestopa6420 Před 2 měsíci

    does this replication works in version 10, too?

  • @kiranpatil2596
    @kiranpatil2596 Před 2 lety

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

  • @nachoci6876
    @nachoci6876 Před 7 měsíci

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

  • @minhhieple6483
    @minhhieple6483 Před rokem

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

  • @candycrushteamplayers4649

    so please for a big company wich architecture is the best

  • @user-pm8yq1vg7y
    @user-pm8yq1vg7y Před 6 měsíci

    So Helpful 👍

  • @durgaprasadpj
    @durgaprasadpj Před rokem

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

  • @ashutoshgamingboy3683
    @ashutoshgamingboy3683 Před 7 měsíci

    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.

  • @mikhatanu
    @mikhatanu Před rokem

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

  • @maheshshetty4088
    @maheshshetty4088 Před 2 lety

    hi can you share the slides used.

  • @amartuvshinbadnainymbuu4674
    @amartuvshinbadnainymbuu4674 Před 7 měsíci

    is it working postgresql 10 version

  • @Hemanthkumar-ic1fu
    @Hemanthkumar-ic1fu Před rokem

    how to do on windows sir

  • @Delicatamente
    @Delicatamente Před 5 měsíci

    huge thanks!