Re: Synchronizing Data?

My only concern with this is the time the web database would be down. I assume
if I wanted to load the pg_dumpall file, I'd have to delete everything from the
database (at least the affected tables) first. Correct? I'd hate for someone to
hit the web just after I had deleted everything and find a broken site, even if
for just a second. However, if there's no way around it...

Joe

Steve Wolfe wrote:

>    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