Postgres复制 [英] Postgres replication

问题描述

现在我在PostgreSQL中有一个数据库(大约2-3 GB)，可作为类似RoR/Python LAMP的应用程序的数据存储.

Right now I have a database (about 2-3 GB) in PostgreSQL, which serves as a data storage to RoR/Python LAMP-like application.

有哪些工具足够简单，强大，可以将主数据库复制到第二台计算机上?

What kind tools are there that are simple and robust enough for replication of the main database to a second machine?

我浏览了一些软件包(Slony-I等)，但也很高兴听到现实生活中的故事.

I looked through some packages (Slony-I and etc.) but it would be great to hear real-life stories as well.

现在我不关心负载平衡等问题.我正在考虑现在使用简单的预写日志策略.

Right now I'm not concerned with load balancing and etc. I am thinking about using simple Write-Ahead-Log strategy for now.

推荐答案

如果不执行复制，则预写日志是最简单的解决方案.

If you are not doing replication, Write ahead Logs are the simplest solution.

这篇关于Postgres复制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！