How to sync 2 database

Hi,

May I know how to setup hot backup?
It mean to sync 2 database database

Any help is welcome?

Such setup should be done at database level.

Assuming postgresql is your backend (what is recommanded for production), please consult Postgresql documentation, and specially Chapter 26. High Availability, Load Balancing, and Replication.

Please note that PostgreSQL is able to do several type of database synchronization depending your requirements, from simple regular snapshot (full backup at some point in time) to full high-availability. The configuration and the technical skill required could be important to properly configure it.

2 Likes