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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-05 04:35:47  来源:igfitidea点击:

synchronization Between two Servers Postgres Database

databaselinuxpostgresql

提问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...

很多选择...