Re: reliable backup techniques - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: reliable backup techniques
Date
Msg-id 20030219140012.Q24136@mail.libertyrms.com
Whole thread Raw
In response to Re: reliable backup techniques  (Jonathan Bartlett <johnnyb@eskimo.com>)
List pgsql-general
On Wed, Feb 19, 2003 at 09:34:15AM -0800, Jonathan Bartlett wrote:
> On Linux, you can use the Linux volume manager, and create a temporary
> snapshot and tar that up.  If you have to go back to it, the database will
> have to recover on startup, just as if the machine had crashed at that
> point.  That's much better than a regular tar, in which the database would
> be likely unrecoverable.

Hmm.  Is it guaranteed to be consistent?  I looked at Veritas for
this purpose, and I gathered there was a small possibility of
inconsistency, so I haven't done it (though I'd like to, because it'd
be much faster under some circumstances).

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: creating table
Next
From: Andrew Sullivan
Date:
Subject: Re: TIMESTAMP WITH( OUT)? TIME ZONE indexing/type choice...