49. PostgreSQL DBA: How to setup streaming replication in PostgreSQL step by step on Ubuntu

[@redmartian]

Thank you for making such a simple step by step method for showing how easy it is to setup postgresql replication between a primary and secondary server. Most other videos are riddled with commentary and too much information/personality, but you get straight to the point. Good job!

[@r2schools]

Glad it helped

[@austonpramodh]

This was a really good video. Thank you sir for all the hard work. Please do not get demotivated due to the number of views or subscribers. This video is for Senior kinds of people who work on high availability systems. I would say the target audience is less. Keep going, sir. Thank you.

[@r2schools]

Thank you, I will

[@sivasaikiran7439]

But, with less views he won't get any money. It's better to we pay some amount. So that it's fare enough.

[@vimsen2221]

My postgresql version is 13. The Totorial worked well without any issues. I substituted 13 instead of 12. Thanks

[@Nighteaglenex]

Thanks for sharing this video, i was chasing a lot in master slave setup. After this video i easily done the setup

[@r2schools]

You're welcome

[@Ketan74847]

Very good Video , you made streaming rep setup very simple, I have seen this video couple of time and than able to setup my own replication.

[@r2schools]

Great to hear!

[@BachelorsBawarchi]

what about parameter which need to set in conf like max_wals max wal senders and what parameeters do we need to set in standbysignal?

[@HumzaArshad-hk4kv]

after running db_backup command i am unable to go inside psql , and getting this error "Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?" Also when i check postgresql service is ok , but cluster is down

[@SayaliChitrakoti]

hello i m facing issue: bash-4.2$ psql could not change directory to "/root": Permission denied psql: error: connection to server on socket "/run/postgresql/.s.PGSQL.5432" failed: No such file or directory Is the server running locally and accepting connections on that socket? plz help to solve this

[@frikabg]

Tried this on Ubuntu 18.04 with psql 10 and it does not work. reason: pg_basebackup: could not send replication command "START_REPLICATION": ERROR: replication slot "test1" does not exist i can't find any information on what the reason for that is however.

[@g46psk]

hi, with this configuration, if master is down will slave be switched automatically?

[@prasenjit135]

Whether this configuration will work in version 9.2

[@S-N_I_P_E-R]

Excellent….can you please do the same on logical replication

[@junaidshahzad5064]

if master goes down then slave still remain in read only mode ? i mean if i have to route my application requests to slave in case of master failure. can we setup master-master replication as well? Also my PostgreSQL version is 11 .

[@mdshahajada]

is it also work on postgres 14.3?

[@p.tharakeswarreddy4788]

Great 💓

[@r2schools]

So glad!

[@niranjanv0]

Very informative video 👍 Bt one question is - How to configure with web application?

[@RK-gk5td]

You are my hero

[@r2schools]

Thank you

[@davidcarvalho2985]

Thank you for this video. It helped me a lot

[@r2schools]

Glad it helped!

[@danitrimujianto1037]

cannot read the table with existing user from master, anyone have same problem?

[@satyamchaudhary5012]

thanks alot, it was helpful

[@r2schools]

Glad it helped!

[@harshpatel7579]

please create the video of postgress cluster create in different server.thanks for support.

[@saketbhushan5495]

Great.... thanks. Liked and subscribed

[@r2schools]

Awesome, thank you!

[@love2592001]

Can you please provide your emailid?