Linux 两台服务器 Postgres 数据库之间的同步
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/6385546/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
synchronization Between two Servers Postgres Database
提问by Pavunkumar
I have two postgres database in different linux server, the thing is that I want to synchronize all the data which are inserted , updated, deleted in SERVER A to SERVER B. Is there any way to do this....? Any one help me ...?
我在不同的 linux 服务器中有两个 postgres 数据库,问题是我想将在 SERVER A 中插入、更新、删除的所有数据同步到 SERVER B。有什么办法可以做到这一点......?有谁帮帮我...?
采纳答案by mihn
Since 9.0 PostgreSQL supplies it own replication. If you use 8.x you can try othersolutions. Personally I used slony and was quite pleased with it.
由于 9.0 PostgreSQL 提供了它自己的复制。如果您使用 8.x,您可以尝试其他解决方案。我个人使用 slony 并且对它非常满意。
回答by Denis de Bernardy
There are many options...
有很多选择...