Re: Re : Very asynchrnous replication system - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Re : Very asynchrnous replication system
Date
Msg-id b6ab4c9662e915d44ebcc8c8def7c5b9@biglumber.com
Whole thread Raw
In response to Re : Very asynchrnous replication system  (Laurent ROCHE <laurent_roche@yahoo.com>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> Bucardo is an interesting project (they've just released
> a new version) but id does not look like they are able to
> perform delayed (or very asynchronous) replication: from
> the information I could gathered Bucardo replicates between
> databases always connected to each other. When I want to
> replicate between "not always on" databases ! !

Sure, Bucardo could do that - just start Bucardo up when you
want to do the sync, kick it off, and shut it down again before
you disconnect from the network. Generally, you'd do this:

Setup Bucardo on one side or the other (it does not matter which).
Add the other database and tables, and describe what should be
synced. This will setup the triggers on both sides. Turn Bucardo
off. Start it up and do the sync when you have a connection.

When the traveller wants to sync with the home base, they simply
connect to the network, start up Bucardo and fire off the sync.
Alternatively, if you don't want to install Bucardo on the remote
computers, Bucardo could live on the "home" system, in which case
it would startup there and fire off the sync when asked to. You
could even run a single Bucardo instance on the home and toggle the
databases from "active" to "inactive" status in the bucardo.db table.

- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200710151116
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFHE4ROvJuQZxSWSsgRA0ytAKD7mKsjuPVb1o5q1It+ytayPnpVCwCgz4OD
lOn8974pHWIMKLrBwuaJwWI=
=79Av
-----END PGP SIGNATURE-----



pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: TSearch chain dictionaries
Next
From: Alan Hodgson
Date:
Subject: Re: Importing MySQL dump into PostgreSQL 8.2