Configure Stream Replication on PostgreSQL Master-Slave Setup | Postgresql Replication Tutorial

This tutorial explains, how to install postgresql 9.6 on ubuntu, how to setup master -slave with stream replication.

[edenhub]

wow, you made it so simple. Thanks a great deal

[mirzaali]

Thank you, Helped me understand better and fast. Excellent video.

[satyamprasad]

Thank you. I was able to set up Replication.

[debasistripathy]

Thanks Rohini mam for uploading these video.I have followed all the steps.Now my master, slave dbs are ready.I want to know if my master db got crashed or got down how slave db will run without doing any disturbance in application.

[yadhukrishnana]

I want master-slave replication in psql on single ec2 instance. How to done that?

[oscarparedes]

Pls a question ❓.. archive files in /var/lib/pgsql/archive when I can delete?

[vinayksingh]

Hello Mam, Thank you for the wonderful tutorial. I did the same steps and able to setup streaming replication in the server. My question is regarding archive directory, my archive directory is getting full very fast with so many WAL logs. How can I clear those ? Any suggestions ?

[srinivasanramkumar]

I did the WALconfiguration, the master is upstreaming the data to the slave database but in my execution, there was a break between my network for 3days, but WAL stopped sending the data to my slave database.

If I need to perform the sync between master to slave is it required to do full database sync? if no is there any possibility to do incremental sync?

[chetanrede]

Location of postgresql.conf and recovery.conf looking different on slave server, can you explain that sernario?

[danieljohnson]

Thanks for this, Can you also post a Failover video or steps please?

[sivanagi]

This was super helpful. Appreciate your time and explanation. Can you attach the steps document to download please?

[Vone_WorldClass]

I have issue with command replication on slave server : pg_basebackup -h 10.10.73.14(primary server IP) -D /var/lib/postgresql/10/main/ -P -U replication -xlog-method-stream
Error: invalid option -- 'x'
Try "pg_basebackup --help" for more information.

[UmeshYadav-amh]

Hi may I know how to configure jboss app to connect with postgres master slave,
I want write data in master and read from slave, please do reply @Appychip

[Zharan_]

any text files or website to get the commmand lists?

[srinivasanramkumar]

Hi it was helping me to take backup, but if i stop my master postgres and try to insert any table or update from slaver database it is not happening..

how can we make slave as master ? if my master postgres down...

[godwintheophilus]

Awesome 🔥 can u post a video with fails over

[antonismakris]

Thanks for the video. With the configuration of stream replication, a distribution of read requests between the two nodes can be achieved? In case of SELECT query, the data are requested from both nodes achieving a load balancing?

[kranthi]

Thanks for this, can you please share link or document which is used to configure it will be helpful...

[sivanagi]

Can you add the pdf file for the steps? So that it will be easy for us copy paste while working on the replication instead of manual work.

[suvamrout]

Hello Mam,
Your video really helpful for me and I followed the same process as per my environment. I am able to take base backup successfully and it's also reflecting master data on slave system after base backup, but continuously backup not happening for me(If I am adding any new data on master it's not reflecting on slave system continuously). My question is that.
Q: Do we need to specify archive location same for backup and recovery for both master and slave ?
Greatfully waiting for your replay.