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})/
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 |