-----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@xxxxxxxxxxxx End Point Corporation PGP Key: 0x14964AC8 200710151116 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFHE4ROvJuQZxSWSsgRA0ytAKD7mKsjuPVb1o5q1It+ytayPnpVCwCgz4OD lOn8974pHWIMKLrBwuaJwWI= =79Av -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
