Re: Synchronizing Data?

From: Andreas Tille <tillea(at)rki(dot)de>
To:
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Synchronizing Data?
Date: 2000-11-07 14:18:10
Message-ID: Pine.LNX.4.21.0011071513110.11378-100000@wr-linux02.rki.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 7 Nov 2000 joe(at)jwebmedia(dot)com wrote:

> 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...
That's why I went the way with the Debian package which avoids manual
work and is as fast as possible (including restarting apache if necessary)
and avoids errors in manual administration. If you can't cope with
some seconds downtime this is no solution for you. For my application
is is enough.

Kind regards

Andreas.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ned Lilly 2000-11-07 14:55:15 announce list?
Previous Message joe 2000-11-07 14:08:12 Re: Synchronizing Data?