Re: reliable backup techniques

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: reliable backup techniques
Date: 2003-02-19 19:00:12
Message-ID: 20030219140012.Q24136@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Copeland 2003-02-19 19:07:40 Re: Table Partitioning in Postgres:
Previous Message Andrew Sullivan 2003-02-19 18:52:49 Re: TIMESTAMP WITH( OUT)? TIME ZONE indexing/type choice...