PostgreSQL 18 Bidirectional Logical Replication on Windows Server 2025 | Step-by-Step #postgresql

🎥 YouTube full video:

https://youtu.be/OeM3Fo5KOUc

# PostgreSQL 18 Bidirectional Logical Replication

## Windows Server 2025 Step-by-Step Guide

Bidirectional replication means both servers replicate changes to each other.

Server1 (Publisher + Subscriber) ------- Server2 (Publisher + Subscriber)
192.168.136.133 192.168.136.141

Changes on either server automatically appear on the other.

+ ------------------------------------------------------------- +
| 🎥 PostgreSQL 18 Installation YouTube full video: |
| |
| https://youtu.be/xjPsx_-ye9A |
+ ------------------------------------------------------------- +

In this video, I will configure Bidirectional Logical Replication only.

# 1. Environment Setup
+ ---------------------- + ------------------- +
| Component | Value |
+ ---------------------- + ------------------- +
| PostgreSQL Version | 18 |
| OS | Windows Server 2025 |
| Publisher + Subscriber | Both servers |
| Server1 | 192.168.136.133 |
| Server2 | 192.168.136.141 |
| Database | testdb |
| Replication User | replicator |
| Password | admin@123 |
+ ---------------------- + ------------------- +

# Architecture

Server1
192.168.136.133
Publisher + Subscriber
│
│ Logical Replication
│
▼
Server2
192.168.136.141
Publisher + Subscriber

# Best Practices
+ ---------------------------- + --------------------------------------- +
| Rule | Reason |
+ ---------------------------- + --------------------------------------- +
| Tables must have PRIMARY KEY | Needed for updates |
| Same schema on both servers | Logical replication doesn't copy schema |
| Avoid sequence conflicts | Prevent duplicate IDs |
| Avoid simultaneous updates | Prevent conflicts |
| Use replica identity | Required for UPDATE/DELETE |
+ ---------------------------- + --------------------------------------- +

# Final Result

Insert on Server1 → replicated to Server2
Insert on Server2 → replicated to Server1
Update → replicated both directions
Delete → replicated both directions

Your PostgreSQL 18 Bidirectional Logical Replication is now working successfully.

--------------------------------------------------------------------
######## ⚠️ Disclaimer / अस्वीकरण ########
1️⃣ All trademarks, logos, and names belong to their respective owners.
2️⃣ This video is made only for educational & informational purposes under Fair Use (Section 107, Copyright Act 1976).
3️⃣ No copyright infringement intended.
4️⃣ For any copyright concerns, email 📩 inchirags@gmail.com — action will be taken promptly.

## 🌐 👇 Follow & Support:
🎥 YouTube: https://www.youtube.com/@ChiragMahtoOfficial
📷 Instagram: https://www.instagram.com/chirag_._mahto
💼 LinkedIn: https://linkedin.com/in/chittrmahto
📘 Facebook: https://www.facebook.com/chittrmahto
💬 WhatsApp Channel: https://whatsapp.com/channel/0029VbBgm16002T93KB16U12
💬 Telegram Channel: https://t.me/+GAATbmOU4z1mMDY9

📘 Note: Follow the process exactly as shown in the video.
💾 DM me for paid PDF/Document → 📩 inchirags@gmail.com

✨ Share this tutorial with your friends & colleagues!
💬 Drop your questions in the YouTube comments — I’ll reply personally.

🔔 Subscribe for FREE tutorial and Certification Tutorials!
🔥 Don’t forget to 💛 LIKE, 💘 SHARE, 💝 COMMENT, & 💙 SUBSCRIBE to @ChiragMahtoOfficial 💯

Thanks & Regards,
💫 Chitt Ranjan Mahto — “CHIRAG” 💫
🌍 https://www.chirags.in

#chiragmahtooffcial #chiragtutorial #chirag #chittranjanmahto #chiragmahto #postgresql #postgresql18 #postgresreplication #logicalreplication #bidirectionalreplication #postgresqltutorial #postgresqlwindows #windowsserver2025 #dbarealworld #databasereplication

Видео PostgreSQL 18 Bidirectional Logical Replication on Windows Server 2025 | Step-by-Step #postgresql канала Chirag Mahto