Search Postgresql Archives

Re: table replication, without master-slave setup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

Shoaib Mir
EnterpriseDB

On 7/14/06, Alexander Bluem <mailinglists1@xxxxxx> 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})/




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux