Re: Synchronizing Data? - Mailing list pgsql-general

From Steve Wolfe
Subject Re: Synchronizing Data?
Date
Msg-id 024701c04844$2ef5a380$50824e40@iboats.com
Whole thread Raw
In response to Synchronizing Data?  (joe@jwebmedia.com)
Responses Re: Synchronizing Data?  (Andreas Tille <tillea@rki.de>)
List pgsql-general
> 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



pgsql-general by date:

Previous
From: joe@jwebmedia.com
Date:
Subject: Re: Synchronizing Data?
Next
From: "Mark Lane"
Date:
Subject: Redundant PostgreSQL Servers