Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M40859=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1UOX5B-0006a1-P3
	for pgsql-admin@arkaria.postgresql.org; Sat, 06 Apr 2013 17:39:17 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M40859=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1UOX5A-0005jB-JA
	for pgsql-admin@arkaria.postgresql.org; Sat, 06 Apr 2013 17:39:16 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <stellr@vt.edu>) id 1UOX59-0005j6-KI
	for pgsql-admin@postgresql.org; Sat, 06 Apr 2013 17:39:15 +0000
Received: from lennier.cc.vt.edu ([198.82.162.213])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <stellr@vt.edu>) id 1UOX50-0008Hb-Gg
	for pgsql-admin@postgresql.org; Sat, 06 Apr 2013 17:39:14 +0000
Received: from steiner.cc.vt.edu (steiner.cc.vt.edu [198.82.163.51])
	by lennier.cc.vt.edu (8.13.8/8.13.8) with ESMTP id r36HcYxJ020838
	for <pgsql-admin@postgresql.org>; Sat, 6 Apr 2013 13:38:34 -0400
Received: from mail-ve0-f199.google.com (EHLO mail-ve0-f199.google.com)
	([209.85.128.199])
	by steiner.cc.vt.edu (MOS 4.3.3-GA FastPath queued)
	with ESMTP id WJO75797; Sat, 06 Apr 2013 13:38:34 -0400 (EDT)
Received: by mail-ve0-f199.google.com with SMTP id jw11so7562961veb.10
	for <pgsql-admin@postgresql.org>; Sat, 06 Apr 2013 10:38:33 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=google.com; s=20120113;
	h=x-received:x-received:subject:mime-version:content-type:from
	:in-reply-to:date:cc:message-id:references:to:x-mailer
	:x-gm-message-state;
	bh=emVAhHjBSChM57yQDehR7QP74rEFVbDqasX+t60raF0=;
	b=KpMQMNqnojYhYWBQcbN3mUKtdMCznU8aewnbYZy+0BehZKV50crsBZFF+F/D3DrftO
	rjyaCTGEO2JW7aQGYrexPRewrAqeU0hVr4yfgeZkkR4mX1CkkA4Kc8yBcNaQL+bv9J0G
	OhAkNyXSTS+jacCMlOnDTQcLzRihhVsVsJdH9C3QKNM95f9yfVxSdY+NPfOJo8+P9RrK
	6rYFk4cQc2hWCBwzdAdCUIfeES/V2L4LEMxKQMYnLlKTy3Y+kpzQtQs+O/0UGOfdEI+X
	N8OCPNWwxSgFo8gGTM+mIe8uEy5zFrudLctSmo5kThXzQOJEfXsNAThKp0L20wu1QP6Y
	BYXw==
X-Received: by 10.49.87.40 with SMTP id u8mr14114636qez.62.1365269913773;
	Sat, 06 Apr 2013 10:38:33 -0700 (PDT)
X-Received: by 10.49.87.40 with SMTP id u8mr14114632qez.62.1365269913696;
	Sat, 06 Apr 2013 10:38:33 -0700 (PDT)
Received: from [192.168.2.2] (pool-71-254-79-40.ronkva.east.verizon.net.
	[71.254.79.40])
	by mx.google.com with ESMTPS id bt19sm17065207qab.0.2013.04.06.10.38.32
	(version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
	Sat, 06 Apr 2013 10:38:33 -0700 (PDT)
Subject: Re: purpose/use of pg_start_backup() pg_stop_backup()
Mime-Version: 1.0 (Apple Message framework v1283)
Content-Type: multipart/alternative;
	boundary="Apple-Mail=_DFB1F8B0-10CD-4BA6-A5F3-453547B235EE"
From: Ray Stell <stellr@vt.edu>
In-Reply-To: <20130406164605.GV24874@reptiles.org>
Date: Sat, 6 Apr 2013 13:38:31 -0400
Cc: pgsql-admin@postgresql.org
Message-Id: <36F8708F-ABE2-4356-A8D3-20F02D2DF614@gmail.com>
References: <20130406164605.GV24874@reptiles.org>
To: Jim Mercer <jim@reptiles.org>
X-Mailer: Apple Mail (2.1283)
X-Gm-Message-State: 
 ALoCoQn4efcsaSwFBq02/jKdfh1zwujuM8wKk+T2iDtIZT4CnYCxYU2tF42ItQ72XS6pIsFpg+y0IZgf9tglFENsmlag/EKd/wExDj5ZeKIBZdq20vhSqCr2YQ/wpPemxzECmshiEaZGf3YXHZuSKhKXjgBlfdMBIYJJG/0x8Ti5nrs3d+Wa0F4=
X-Mirapoint-Received-SPF: 209.85.128.199 mail-ve0-f199.google.com
	stellr@vt.edu 4 softfail
X-Junkmail-Status: score=10/50, host=steiner.cc.vt.edu
X-Junkmail-Signature-Raw: score=unknown,
	refid=str=0001.0A020207.51605D9A.0029,ss=1,re=0.000,fgs=0,
	ip=0.0.0.0, so=2011-07-25 19:15:43,
	dmn=2011-05-27 18:58:46, mode=single engine
X-Junkmail-IWF: false
X-Pg-Spam-Score: -5.0 (-----)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


--Apple-Mail=_DFB1F8B0-10CD-4BA6-A5F3-453547B235EE
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii


On Apr 6, 2013, at 12:46 PM, Jim Mercer wrote:
>=20
> can someone provide a walk-through of using these functions both for=20=

> a backup and a restore?


=
http://www.postgresql.org/docs/9.2/interactive/continuous-archiving.html#B=
ACKUP-PITR-RECOVERY

24.3. Continuous Archiving and Point-in-Time Recovery (PITR)

24.3.4. Recovering Using a Continuous Archive Backup=

--Apple-Mail=_DFB1F8B0-10CD-4BA6-A5F3-453547B235EE
Content-Transfer-Encoding: 7bit
Content-Type: text/html;
	charset=us-ascii

<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>On Apr 6, 2013, at 12:46 PM, Jim Mercer wrote:</div><blockquote type="cite"><div><font class="Apple-style-span" color="#000000"><br></font>can someone provide a walk-through of using these functions both for <br>a backup and a restore?<br></div></blockquote></div><div><br></div><div><h1 class="SECT1"><a name="CONTINUOUS-ARCHIVING" id="CONTINUOUS-ARCHIVING"><font class="Apple-style-span" size="3">http://www.postgresql.org/docs/9.2/interactive/continuous-archiving.html#BACKUP-PITR-RECOVERY</font></a></h1><h1 class="SECT1"><a name="CONTINUOUS-ARCHIVING" id="CONTINUOUS-ARCHIVING"><font class="Apple-style-span" size="3">24.3. Continuous Archiving and
  Point-in-Time Recovery (PITR)</font></a></h1><h1 class="SECT1"><span class="Apple-style-span" style="font-size: medium; "><a name="BACKUP-PITR-RECOVERY" id="BACKUP-PITR-RECOVERY">24.3.4. Recovering Using a Continuous
    Archive Backup</a></span></h1></div></body></html>
--Apple-Mail=_DFB1F8B0-10CD-4BA6-A5F3-453547B235EE--