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
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... |