Re: Table replication

From: Richard Huxton <dev(at)archonet(dot)com>
To: S Arvind <arvindwill(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Table replication
Date: 2009-07-09 10:53:58
Message-ID: 4A55CC46.6010602@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

S Arvind wrote:
> Hi Members,
> Is there any way to sync a single table across the DBs. We need a single
> table alone to be equal in all DBs in the single postgres. Presenly we are
> doing this with the help of Update, insert, delete trigger.
> Is there any other best way for that.

Most trigger-based replication systems should work fine with one or more
tables: slony, londiste etc. That's assuming a single master DB that
receives all updates.

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Geoghegan 2009-07-09 12:08:24 Re: c++ program to connect to postgre database
Previous Message Dave Page 2009-07-09 10:27:35 Re: pg_dump PostgreSQL 8.4