Postgresql:1 个表的主从复制 [英] Postgresql: master-slave replication of 1 table

问题描述

帮助我为两个 Postgresql 数据库之间一个表的主从复制提供一个简单(轻量级)的解决方案.该表包含一个大对象.

Help me to chouse a simple (lightweight) solution to the master-slave replication of one table between two Postgresql databases. The table contains a large object.

推荐答案

这里 您将找到有关 PostgreSQL 复制工具的非常好的概述.请看一看，希望你能从中挑选一个.

Here you'll find a very good overview of the replication tools for PostgreSQL. Please, take a look and hopefully you'll be able to pick one.

否则，如果你需要一些非常轻量级的东西，你可以自己做.你需要一个触发器和几个函数，一个 dblink 模块如果您需要几乎立即更改传播，否则您可以使用 cron 生存.

Otherwise, if you need something really lightweight, you can do it yourself. You'll need a trigger and a couple of functions, a dblink module if you need almost immediate changes propagation, otherwise you can survive with cron.

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