table replication, without master-slave setup

From: Alexander Bluem <mailinglists1(at)gmx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: table replication, without master-slave setup
Date: 2006-07-14 11:55:34
Message-ID: 20060714135534.5d7c0061@laplace.w26.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have a certain setup, so that two computers are running nearly
identical databases: identical setup, tables, users and permissions,
only the contents differ. Now I'd like to keep them in sync, WITHOUT an
extra machine, hence master-slave setup. The problem is, that either one
could fail eventually. Either one or the other machine (with the same
database) get data, but not yet both at the same time. This is some sort
of load balancing.
Is there software out there that "rsyncs" database tables both ways? Or
will I have to write scripts for this task? I've already taken a look at
Slony but it is unfortunately a "master to multiple slaves". And I want
both (or maybe in future three) machines to communicate with each other.
That means one gets data, and sends it to other machines running the
same db.

Cheers,
Alex

--

shakespeare:
/(bb|[^b]{2})/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-07-14 12:13:22 Re: How to read cleartext user password from pgsql database
Previous Message Eugene Prokopiev 2006-07-14 11:21:01 How to read cleartext user password from pgsql database