1. Streaming Replication for High Availability

• We set up Streaming Replication to maintain one or more real-time hot standby servers that mirror your primary PostgreSQL database.
• In the event of a failure, standby nodes are ready to take over — ensuring your Odoo system remains online with minimal downtime.
• We configure streaming or logical replication, depending on your latency and availability requirements.

2. Logical Replication for Targeted Syncing

• In contrast to physical replication, logical replication enables the selective synchronization of individual tables between databases.
• This is useful for syncing select data (like customers, products, or orders) across different Odoo environments — such as between regional offices or production and staging environments.
• It avoids full database duplication, saving on storage and reducing replication overhead.

3. Replication Monitoring and Failover Automation

• We implement monitoring and alerting tools to track replication lag, node status, and WAL (Write-Ahead Log) performance.
• We use tools like Patroni, Etcd, and pg_auto_failover to provide automatic failover, ensuring continuity without manual intervention.
• Our setups are tested against real failure scenarios to ensure resilience under pressure

4. Custom Research for Better Availability

• We continuously evaluate new PostgreSQL features, such as bidirectional replication (BDR) and logical decoding enhancements, for advanced use cases.
• Our team regularly explores better ways to integrate replication with Odoo’s ORM and load balancing mechanisms.