@@Appychip Thank you for the detailed tutorial. Could you also do it for PostgreSQL 10.15? I'm trying to setup High-Availability for my Django project.
@@imtiazahmed156 We are glad that this video was helpful. We will surely try to make video on it. Please like, share and subscribe for upcoming videos and to keep us motivated. Keep Learning & Keep Sharing :)
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.
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 ?
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?
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?
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
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: /usr/lib/postgresql/10/bin/pg_basebackup: invalid option -- 'x' Try "pg_basebackup --help" for more information.
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...
We are glad to know that our tutorial helped you. To promote slave server as a master server, you have to create trigger file on the slave server, that you mentioned in the configuration. Please like and subscribe to keep us motivated
thanks for your response, can you please say if my master comes up and the data which was collected on slave server will be synced back to master database? Also place share me the steps to configure trigger that's helps me to complete my RD and deploy in my customer setup.
By default, the slave data won't get sync on master, when master will come up. You have to again setup replication. Regarding your second doubt, we specify trigger file location in slave's recovery.conf file. As per video, location of trigger file is `/var/lib/postgresql/9.6/2/trigger`. When you will create this file on slave server, it will get promote as master.
Okay one small doubt should be create once replication user in slave also ? Below is the error i am getting once i stop the master and try to insert into slave.. srini=# insert into srinivijay values ('vijay', '22'); ERROR: cannot execute INSERT in a read-only transaction please advice..
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.
Thanks for referring the video. Can you help us with exact error and more context regarding the error. It will help us to understand the issue better and come up with a right solution.
This is not working for PostgreSQL 12... so my adventure is over :) pg_basebackup -h 192.168.1.185 -D /var/lib/postgresql/12/main -P -U replication --xlog-method=stream
![Set Up PostgreSQL Replication in 4 Steps [With Examples]](http://i.ytimg.com/vi/VtBVofpdXyk/mqdefault.jpg)
wow, you made it so simple. Thanks a great deal
We are glad that you found it useful. Thanks for leaving positive feedback, this keeps us motivated to post more such useful videos.
- Team
Thank you, Helped me understand better and fast. Excellent video.
We are glad to hear that. Please like and subscribe to keep us motivated. Keep Learning & Keep Sharing
Thank you. I was able to set up Replication.
We are glad to hear this. Please like, share and subscribe to keep us motivated. Keep Learning & Keep Sharing :)
@@Appychip Thank you for the detailed tutorial. Could you also do it for PostgreSQL 10.15? I'm trying to setup High-Availability for my Django project.
@@imtiazahmed156 We are glad that this video was helpful. We will surely try to make video on it. Please like, share and subscribe for upcoming videos and to keep us motivated. Keep Learning & Keep Sharing :)
Pls a question ❓.. archive files in /var/lib/pgsql/archive when I can delete?
Thanks for this , Can you also post a Failover video or steps please?
Connect via whatsapp to +91-9999287640 for stream replication in sync and async mode with EFM..
I want master-slave replication in psql on single ec2 instance. How to done that?
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.
Location of postgresql.conf and recovery.conf looking different on slave server ,can you explain that sernario?
This was super helpful. Appreciate your time and explanation. Can you attach the steps document to download please?
We are glad that you found it useful. Thanks for leaving positive feedback, this keeps us motivated to post more such useful videos.
- Team Appychip
mam please make video on failover and load balancing part also
Glad you found it useful! Sure, we will pass the feedback to the person!
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 ?
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?
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?
Connect via whatsapp to +91-9999287640 for understanding about load balancing in EDB PostgreSQL
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.
Sure, we will pass your feedback to our content team. Thanks!
Thanks for this, can you please share link or document which is used to configure it will be helpful...
any text files or website to get the commmand lists?
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
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: /usr/lib/postgresql/10/bin/pg_basebackup: invalid option -- 'x'
Try "pg_basebackup --help" for more information.
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...
We are glad to know that our tutorial helped you. To promote slave server as a master server, you have to create trigger file on the slave server, that you mentioned in the configuration.
Please like and subscribe to keep us motivated
thanks for your response, can you please say if my master comes up and the data which was collected on slave server will be synced back to master database?
Also place share me the steps to configure trigger that's helps me to complete my RD and deploy in my customer setup.
By default, the slave data won't get sync on master, when master will come up. You have to again setup replication. Regarding your second doubt, we specify trigger file location in slave's recovery.conf file. As per video, location of trigger file is `/var/lib/postgresql/9.6/2/trigger`. When you will create this file on slave server, it will get promote as master.
Okay one small doubt should be create once replication user in slave also ?
Below is the error i am getting once i stop the master and try to insert into slave..
srini=# insert into srinivijay values ('vijay', '22');
ERROR: cannot execute INSERT in a read-only transaction
please advice..
Hi team plz advice on the above...
Thanks, very helpful
We are glad that it helped you. Please like and subscribe to keep us motivated.
Keep Learning & Keep Sharing
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.
Please check if replication user is setup correctly and its related configurations in pg_hba.conf file.
Thanks for your video , please share the text file if possible
Awesome 🔥 can u post a video with fails over
Thanks for Share Good Information. If you dont mine can you share the same replications method in windows servers.
Thank-You for your kind word. We will try to make a tutorial for windows whenever time permits. Keep Learning & Keep Sharing
Thanks for the video. I'm interesting too to know how this replication run in windows
Hi, would you please share me the text file or link of that?
How to open slave server port 5432
i do the same step and have this error pg_control no found
Thanks for referring the video. Can you help us with exact error and more context regarding the error. It will help us to understand the issue better and come up with a right solution.
can you please provide me the cascading replication postgresql document.
With Regards
Connect via whatsapp to +91-9999287640 for stream replication in sync and async mode with EFM..Even cascading techniques
Can u share similar video
We will try to make similar video. Thanks for watching. Please like and subscribe to keep us motivated
Can u share the current video link as it is freased in first screen
@@jenitorthomson9477 Here it is - ruclips.net/video/XFp8wHNtP3s/видео.html
i need the guide on pdf
We will try to create a pdf/blog post for the same. Please like and subscribe to receive the notification. Keep Learning & Keep Sharing :)
This is not working for PostgreSQL 12... so my adventure is over :)
pg_basebackup -h 192.168.1.185 -D /var/lib/postgresql/12/main -P -U replication --xlog-method=stream
Connect via whatsapp to +91-9999287640 for stream replication in sync and async mode with EFM..
replace wal with xlog