Скачать или смотреть (हिन्दी में) Streaming Replication of PostgreSQL 17 in Ubuntu 24.04 LTS

Tutorial Link:
https://www.chirags.in/tutorial/index...


[email protected] Chirag's PostgreSQL DBA Tutorial https://www.chirags.in
*************************************************************************************
*
Streaming Replication of PostgreSQL 17 in Ubuntu 24.04 LTS *
*
*************************************************************************************

This comprehensive guide provides detailed instructions for setting up streaming replication between two PostgreSQL 17 servers on Ubuntu 24.04 LTS. We will configure one server as the primary (master) and the other as the standby (replica). The replication will be secured with the password admin@123.

Server Details:

Primary Server (Master) IP: 192.168.224.134
Standby Server (Replica) IP: 192.168.224.135
Replication User Password: admin@123

Prerequisites

Two Ubuntu 24.04 LTS Servers: One will act as the primary server, and the other as the standby server.
PostgreSQL 17 Installed: On both servers.
Root or Sudo Access: Administrative privileges to install and configure software.
Network Connectivity: Both servers should be able to communicate over the network.

Table of Contents

Install PostgreSQL 17 on Both Servers
Configure the Primary Server (Master)
Create a Replication User
Configure PostgreSQL Settings
Adjust Authentication Methods
Reload PostgreSQL Service
Configure the Standby Server (Replica)
Stop PostgreSQL Service
Clear Existing Data Directory
Take a Base Backup from Primary
Configure Recovery Settings
Start PostgreSQL on Standby Server
Verify Streaming Replication
Testing Failover (Optional)
Conclusion

For any doubts and query, please write on YouTube video comments section.

Note : Flow the Process shown in video.

😉Please, Subscribe and like for more videos:
   / @chiragtutorial  
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Tutorial Link :
https://www.chirags.in/tutorials/Post...

Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_________________________________________________________________________________________
Note: All scripts used in this demo will be available in our website.
Link will be available in description


#postgres
#postgresql
#pointintimerecovery
#postgresqlTutorial
#pg_basebackup
#chiragstutorial
#chiragsdatabasetutorial
#database
#psql
#pgbouncer
#patroni
#pgpool
#pgpool2
#pgpoolII
#replication