pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-admin@postgresql.org
Subject: Re: restore challenge
Date: Thu, 17 Nov 2005 16:24:39 -0500
Message-ID: <20051117212439.GA26696@phlogiston.dyndns.org> (raw)
In-Reply-To: <60fypvgkol.fsf@dba2.int.libertyrms.com>
References: <012701c5ea9a$dbab31a0$5605a8c0@ng3054>
	<dli7ta$18ho$1@news.hub.org>
	<60fypvgkol.fsf@dba2.int.libertyrms.com>

On Thu, Nov 17, 2005 at 02:04:42PM -0500, Chris Browne wrote:
> If your OS or disk hardware supports some sort of "snapshotting"
> technology, so that you can grab a copy of the whole thing as an
> instant atomic operation, that provides a way to grab a copy while
> postmaster is running.  If not, then you have to take a copy while the
> postmaster is shut down.

It's also worth noting that you _really really_ want to test that
snapshotting capability.  I've heard some people grumble about "it
didn't work for me" or some such.  There are others who've reported
it works (and it ought to, if the snapshots work as advertised --
just be sure you know what the snapshots actually are).

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism. 
                --Brad Holland



view thread (5+ messages)  latest in thread

Message-ID: <20051117212439.GA26696@phlogiston.dyndns.org>
Permalink:  ../20051117212439.GA26696@phlogiston.dyndns.org/
Also on:    postgresql.org/message-id/20051117212439.GA26696@phlogiston.dyndns.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: ajs@crankycanuck.ca
  Subject: Re: restore challenge
  In-Reply-To: <20051117212439.GA26696@phlogiston.dyndns.org>
  References: <012701c5ea9a$dbab31a0$5605a8c0@ng3054> <dli7ta$18ho$1@news.hub.org> <60fypvgkol.fsf@dba2.int.libertyrms.com> <20051117212439.GA26696@phlogiston.dyndns.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox