Re: do I need replication or something else?

On Tue, 2005-03-29 at 12:58 -0600, Caleb Simonyi-Gindele wrote:
> We have a billing system and we want the ability to send users out into
> the field with an unconnected (no WAN, VPN etc) laptop containing our pg
> db and software. Upon their return we need to synchronize changes to the
> main db. We would like the ability to be able to have this accomplished
> at the db level rather than doing this in our app.
>

What do you mean by "synchronize". Sometimes that's an easy problem,
sometimes that's a hard problem, and sometimes that's an impossible
problem.

If it's something simple, like just UNIONing the data, it's very
possible. You can use Slony-I (<http://www.slony.info>) to do that. Just
make two tables, and have the laptop be the master for table1 and the
slave for table2, and have the main db server be master for table2 and
slave for table1. Then just have a view on each db that's the union of
those two tables.

Regards,
Jeff Davis