Replication advice Many-to-one Slony - Mailing list pgsql-admin

From Walfred Tedeschi
Subject Replication advice Many-to-one Slony
Date
Msg-id 20071018114038.M97749@biomag.usp.br
Whole thread Raw
Responses Re: Replication advice Many-to-one Slony  (Aldor <aldnin@yahoo.de>)
List pgsql-admin
Hi all,

We intend to establish a central back-up for our system. It can be though as
many machines (masters) linked to one Slave. The communication may be one
directional (master -> slave) and would appreciate to have it almost in realtime.
The data flux on the system is not very high in terms of transactions and
volume of data. And the primary keys are planned in a way that there is no
overlap over the masters (every master has its own range of PK) without
overlapping. We were thinking about slony1.

Since we are not sure about the decision, we would appreciate very much if you
could advise us what to use and where to start.

Thank you very much,

Fred


--
Open WebMail Project (http://openwebmail.org)


pgsql-admin by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Is my database now too big?
Next
From: "Peter Koczan"
Date:
Subject: Re: convert char to varchar