Thread: replication

replication

From
"Jean-Yves F. Barbier"
Date:
Hi list,

My architecture will be composed by a central server and several satellites
(POS); the central will have all satellites stock into one DB and its own
items too.

As we sometimes can have internet failure, I'd like to also have local
databases into satellites (only with their own items) to continue sales, and
resynchronize as soon as the failure is fixed with the central.
(and IF possible, synchronize bidir, as the central also is able to sell
satellites items.)

How could I achieve this? (there's no third party software between clients and
server.)

JY
--
I'm glad I was not born before tea.
        -- Sidney Smith (1771-1845)

Re: replication

From
Craig Barnes
Date:
On 22 February 2011 01:35, Jean-Yves F. Barbier <12ukwn@gmail.com> wrote:
On Mon, 21 Feb 2011 21:31:35 +0000, Craig Barnes <cjbarnes18@gmail.com> wrote:

> Hi JY,
>
> There is a section in the manual that references a numerous replication
> solutions.
> http://www.postgresql.org/docs/current/static/different-replication-solutions.html
>
> For Asynchronous Multimaster Replication Bucardo <http://bucardo.org/> is
> mentioned, although I have no first hand experience with it.

Hey Craig,

Thanks for this link (I missed it!), I think I'll find what I want into this
page :)

JY
--
Opium is very cheap considering you don't feel like eating for the next
six days. -- Taylor Mead, famous transvestite