I have two postgres database in different linux server, the thing is that I want to synchronize all the data which are inserted , updated, 开发者_StackOverflow中文版deleted in SERVER A to SERVER B. Is there any way to do this....? Any one help me ...?
Since 9.0 PostgreSQL supplies it own replication. If you use 8.x you can try other solutions. Personally I used slony and was quite pleased with it.
There are many options...
精彩评论