On Thu, Jun 13, 2002 at 04:57:16PM -0500, Kirk Strauser wrote: > > At 2002-06-13T21:26:22Z, Ragnar Kjørstad <[EMAIL PROTECTED]> writes: > > > The easiest way to snapshot the filesystem is to use a logical volume > > manager (LVM or EVMS on linux) and then do: > > 1. take database offline > > 2. take snapshot > > 3. take database online > > 4. backup from snapshot > > 5. remove snapshot > > I'm on FreeBSD-STABLE right now, so that's unfortunately not an option at > the moment. I'm interested that you include steps #1 and #3, though. On > FreeBSD-CURRENT, the snapshot is atomic. There wouldn't be a need to stop > or restart any services. Is it different on Linux?
snapshot is atomic on linux as well, but by shutting the database down first you allow postgresql to shut down cleanly. If fsync is enabled and so on you should still be able to start with a consistant database, so I suppose it's not strictly required. -- Ragnar Kjørstad Big Storage
