Two database synchronization problems! 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?
Reply to discussion (solution)
I wonder if PostgreSQL has a master slave.
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.
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