Re: table replication, without master-slave setup

You can use 'pgpool' (http://pgpool.projects.postgresql.org/) for that
purpose.

Shoaib Mir
EnterpriseDB

On 7/14/06, Alexander Bluem <mailinglists1(at)gmx(dot)de> wrote:
>
> 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})/
>
>
>