Two database synchronization problems! Urgent !! How can I synchronize databases on two servers? one is A local server and the other is a computer server. then I want to create A data table a & nbsp; & nbsp; it is specially used for synchronization & nbsp; the corresponding data table B database on server B is PostgreSQL & nbsp; can I use php to write a script for implementation? ------ Solve two database synchronization problems! Urgent !!
How to synchronize databases on two servers
One is a local server, and the other is a computer server.
Then I want to create A data table a on server A to synchronize the corresponding data Table B on server B.
The database is from PostgreSQL.
Can I use php to write a script for implementation?
------ Solution ----------------------
I wonder if PostgreSQL has a master slave.
------ Solution ----------------------
Use the built-in master/slave databases!
If the master-slave mode is not required,
Then try to export the SQL statement of the entire database and import it again! Although the membership fee is made, he will not make a mistake.
------ Solution ----------------------
Http://www.baidu.com? Ie = UTF-8 & f = 8 & rsv_bp = 1 & tn = 94340107_hao_pg & wd = PostgreSQL % E5 % 90% 8C % E6 % AD % A5 & rsv_enter = 1 & rsv_sug3 = 14 & rsv_sug4 = 299 & rsv_sug1 = 4 & rsv_sug2 = 0 & inputT = 15435 & rsv_sug = 1