Re: Synchronizing Data?

> I'd be glad to. Here's the deal:
>
> I have a client who has a Linux (RedHat 6.2) server that he uses to
> add/modify/delete records for his e-comm site. He is on a metered ISDN
line
> (only thing availble in the area for what he wanted to spend...) and does
not
> what to be 'online' (it's so screwed up...) to add all of his records.
> Anyway...so he's adding/modifying/deleting records on his local server and
we
> need to get that data up to the web server. In addition to putting his
changes
> up, we need to remove any ordered items (from the web site) from the
database,
> once he has synchronized it with his most recent data. Then, obviously, it
> needs to go back down to his local machine so he has the most current
records
> to work with. It's really a big mess. Any ideas? Thanks,

It seems like it's not something that needs to be done in real-time. Am
I correct? If so, then soing a pg_dumpall, gzip it up, and restore on the
other server is probably the way to go.

steve