From jigar@aggregateknowledge.com Fri Aug  27 18:54:32 2010
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 843216326AB
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 27 Aug 2010 15:54:32 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 84750-01-3
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 27 Aug 2010 18:54:24 +0000 (UTC)
X-Greylist: delayed 00:08:46.719268 by SQLgrey-1.7.6
Received: from mx1.myoutlookonline.com (mx1.myoutlookonline.com
 [64.95.72.238])
	by mail.postgresql.org (Postfix) with ESMTP id 37A20634284
	for <pgsql-admin@postgresql.org>; Fri, 27 Aug 2010 15:54:25 -0300 (ADT)
Received: from st020.mx1.myoutlookonline.com (localhost [127.0.0.1])
	by mx1.myoutlookonline.com (Postfix) with ESMTP id 448D88BD07A
	for <pgsql-admin@postgresql.org>; Fri, 27 Aug 2010 14:45:36 -0400 (EDT)
X-Virus-Scanned: by SpamTitan at mail.lan
Received: from mx1.myoutlookonline.com (unknown [10.110.2.1])
	by mx1.myoutlookonline.com (Postfix) with ESMTP id 59ABC8BD03B
	for <pgsql-admin@postgresql.org>; Fri, 27 Aug 2010 14:45:35 -0400 (EDT)
Received: from mx1.myoutlookonline.com ([10.110.13.26]) by
	mx1.myoutlookonline.com with Microsoft SMTPSVC(6.0.3790.3959);
	Fri, 27 Aug 2010 14:44:30 -0400
Received: from [192.168.1.178] ([140.239.90.244]) by mx1.myoutlookonline.com
	with Microsoft SMTPSVC(6.0.3790.3959);
	Fri, 27 Aug 2010 14:44:30 -0400
User-Agent: Microsoft-Entourage/12.24.0.100205
Date: Fri, 27 Aug 2010 11:45:29 -0700
Subject: Use hardware snapshots to restore postgres
From: jigar shah <jigar@aggregateknowledge.com>
To: <pgsql-admin@postgresql.org>
Message-ID: <C89D55D9.20411%jigar@aggregateknowledge.com>
Thread-Topic: Use hardware snapshots to restore postgres
Thread-Index: ActGGAUqVuDWT/h1VEm2L7ycbsvaDg==
Mime-version: 1.0
Content-type: multipart/alternative;
	boundary="B_3365754334_77663968"
X-OriginalArrivalTime: 27 Aug 2010 18:44:30.0320 (UTC)
	FILETIME=[E2304F00:01CB4617]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.699 tagged_above=-10 required=5
	tests=BAYES_20=-0.001, HTML_MESSAGE=0.001, MIME_QP_LONG_LINE=0.001,
	RCVD_IN_DNSWL_LOW=-0.7
X-Spam-Level: 
X-Archive-Number: 201008/263
X-Sequence-Number: 35512

> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--B_3365754334_77663968
Content-type: text/plain;
	charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable

Postgres Guru=B9s

Do you guys know the procedure to use hardware snapshots (for eg 3par) to
restore postgres database? Is there somewhere I can find good documentation
to do this?=20

I=B9d like to do the following

# put the database in the backup mode
# take an filesystem snap
# get the database out of the backup mode
# mount the snap on a different host
# bring up postgres and start querying.

Help appreciated

Regards
Jigar 

--B_3365754334_77663968
Content-type: text/html;
	charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable

<HTML>
<HEAD>
<TITLE>Use hardware snapshots to restore postgres</TITLE>
</HEAD>
<BODY>
<FONT FACE=3D"Calibri, Verdana, Helvetica, Arial"><SPAN STYLE=3D'font-size:11pt=
'>Postgres Guru&#8217;s<BR>
<BR>
Do you guys know the procedure to use hardware snapshots (for eg 3par) to r=
estore postgres database? Is there somewhere I can find good documentation t=
o do this? <BR>
<BR>
I&#8217;d like to do the following<BR>
<BR>
# put the database in the backup mode<BR>
# take an filesystem snap<BR>
# get the database out of the backup mode<BR>
# mount the snap on a different host<BR>
# bring up postgres and start querying.<BR>
<BR>
Help appreciated<BR>
<BR>
Regards<BR>
Jigar </SPAN></FONT>
</BODY>
</HTML>


--B_3365754334_77663968--





From jshah1982@gmail.com Sat Aug  28 01:57:43 2010
Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id D67C1634C26
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 27 Aug 2010 22:57:43 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 26213-03 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 28 Aug 2010 01:57:32 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com
	[74.125.82.174])
	by mail.postgresql.org (Postfix) with ESMTP id 1EE8C634559
	for <pgsql-admin@postgresql.org>; Fri, 27 Aug 2010 22:57:31 -0300 (ADT)
Received: by wyb35 with SMTP id 35so4267217wyb.19
	for <pgsql-admin@postgresql.org>; Fri, 27 Aug 2010 18:57:29 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:date:message-id
	:subject:from:to:content-type;
	bh=bnmlNfuf7gwmnv0ta7QOZfUsdvrR4kmU9zp30UzikCc=;
	b=W7idzM6fFZWG4fizgtN5I1PyrWSWjowPvlGU7T5S6/nv2J4qIc6sAxkVGd/htao8TW
	+HVeH8klrR6M6i6riqS2/l5FNwG634lKviZLYC5AWXRDHocfHabnhiHVKNpIXFpUu5hd
	5XwzSR9+Q3At9sb/GndH88OewR6wwkM90NBBQ=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=liElIg7G8Ja2Uur6MRFv2aD+PG72pTgNDuG+GCiLWcgr4IG6Vwf1o6LhXzJpslB1Ld
	gQOEtRiI9Y0aNztXA69f4h/gO0AnBolpYCUqzMwAYyFOJMH7SbAqhuXVSs7ks47deo8v
	DsraB1l9e9K1LuZNxxOCJGYXSFiZUh6aKOJbI=
MIME-Version: 1.0
Received: by 10.227.156.143 with SMTP id x15mr1595594wbw.39.1282960649801;
	Fri, 27 Aug 2010 18:57:29 -0700 (PDT)
Received: by 10.227.136.209 with HTTP; Fri, 27 Aug 2010 18:57:29 -0700 (PDT)
Date: Fri, 27 Aug 2010 18:57:29 -0700
Message-ID: <AANLkTingzP8Et1NcQTM=nXfRrD4-H3DXn3jaXVKqJZQF@mail.gmail.com>
Subject: Use hardware snapshots to restore postgres
From: jigar shah <jshah1982@gmail.com>
To: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary=0016364d2c1fcacf59048ed88d61
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201008/261
X-Sequence-Number: 35510

--0016364d2c1fcacf59048ed88d61
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

 Postgres Guru=92s

Do you guys know the procedure to use hardware snapshots (for eg 3par) to
restore postgres database? Is there somewhere I can find good documentation
to do this?

I=92d like to do the following

# put the database in the backup mode
# take an filesystem snap
# get the database out of the backup mode
# mount the snap on a different host
# bring up postgres and start querying.

Help appreciated

Regards
Jigar


--=20
"luck is truly where preparation meets opportunity"
--Randy Pausch

--0016364d2c1fcacf59048ed88d61
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

=A0<font face=3D"Calibri, Verdana, Helvetica, Arial"><span style=3D"font-si=
ze: 11pt;">Postgres Guru=92s<br>
<br>
Do you guys know the procedure to use hardware snapshots (for eg 3par) to r=
estore postgres database? Is there somewhere I can find good documentation =
to do this? <br>
<br>
I=92d like to do the following<br>
<br>
# put the database in the backup mode<br>
# take an filesystem snap<br>
# get the database out of the backup mode<br>
# mount the snap on a different host<br>
# bring up postgres and start querying.<br>
<br>
Help appreciated<br>
<br>
Regards<br>
Jigar <br>
</span></font>
<br clear=3D"all"><br>-- <br>&quot;luck is truly where preparation meets op=
portunity&quot;<br>--Randy Pausch<br>

--0016364d2c1fcacf59048ed88d61--



From scott.marlowe@gmail.com Sat Aug  28 06:24:31 2010
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 2358B632397
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 28 Aug 2010 03:24:31 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 10929-06 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 28 Aug 2010 06:24:23 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com
	[74.125.82.174])
	by mail.postgresql.org (Postfix) with ESMTP id B8C706321B4
	for <pgsql-admin@postgresql.org>; Sat, 28 Aug 2010 03:24:23 -0300 (ADT)
Received: by wyb35 with SMTP id 35so4466562wyb.19
	for <pgsql-admin@postgresql.org>; Fri, 27 Aug 2010 23:24:22 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:cc:content-type
	:content-transfer-encoding;
	bh=3rZLKIHTZu5QnvWOvmydr+WMnDhFAY79/otqdPk0rEU=;
	b=F/DpvK0r3frl1q0stAizrmS/JDXl649bNdsVNNGrnPrGAIdle0SHCG/oQc4XMhVxq6
	0lClqXQ2LqWxY5p1H3vhR+XNqtTF7sPU8Wz16/3hiY8HNsKFKdG1/S2Y37i4TZeAivBa
	6f2/e54wmwDiemM62lM61+MIf0Sic2NBt8Xyk=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=IN4wXV57fuzO95flvV9pl8XwyOXn2+FMmH+qVrjmWdf3VRtZGAO5WfPG2zQppDkO7T
	nHm7qx5UP1yhF+B5CaIlwjPCXsYgfxgcOF9MQdU35tEICBwwJDeo5pXD0ID9/gFY7cDQ
	Hekl8ocAliEXVd00sQs77/qiZf8K49i+izga8=
MIME-Version: 1.0
Received: by 10.227.148.5 with SMTP id n5mr1649441wbv.191.1282976659492; Fri,
	27 Aug 2010 23:24:19 -0700 (PDT)
Received: by 10.227.148.75 with HTTP; Fri, 27 Aug 2010 23:24:19 -0700 (PDT)
In-Reply-To: <AANLkTingzP8Et1NcQTM=nXfRrD4-H3DXn3jaXVKqJZQF@mail.gmail.com>
References: <AANLkTingzP8Et1NcQTM=nXfRrD4-H3DXn3jaXVKqJZQF@mail.gmail.com>
Date: Sat, 28 Aug 2010 00:24:19 -0600
Message-ID: <AANLkTim4hj_nKixQMHCqDDH+2vkugHeW-pf4Hv4kHs9a@mail.gmail.com>
Subject: Re: Use hardware snapshots to restore postgres
From: Scott Marlowe <scott.marlowe@gmail.com>
To: jigar shah <jshah1982@gmail.com>
Cc: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201008/262
X-Sequence-Number: 35511

On Fri, Aug 27, 2010 at 7:57 PM, jigar shah <jshah1982@gmail.com> wrote:
> =A0Postgres Guru=92s
>
> Do you guys know the procedure to use hardware snapshots (for eg 3par) to
> restore postgres database? Is there somewhere I can find good documentati=
on
> to do this?

http://www.postgresql.org/docs/8.4/interactive/continuous-archiving.html

is a good place to start.



From 274040551@qq.com Sat Aug  28 13:41:38 2010
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 60A526328B7
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 28 Aug 2010 10:41:38 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 23092-04 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 28 Aug 2010 13:41:29 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158])
	by mail.postgresql.org (Postfix) with ESMTP id 8D8F5633737
	for <pgsql-admin@postgresql.org>; Sat, 28 Aug 2010 10:41:31 -0300 (ADT)
Received: from sam.nabble.com ([192.168.236.26])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <274040551@qq.com>) id 1OpLLA-0000ZM-Dh
	for pgsql-admin@postgresql.org; Sat, 28 Aug 2010 06:21:00 -0700
Date: Sat, 28 Aug 2010 06:21:00 -0700 (PDT)
From: yj2133011 <274040551@qq.com>
To: pgsql-admin@postgresql.org
Message-ID: <1283001660405-2795381.post@n5.nabble.com>
In-Reply-To: <AANLkTingzP8Et1NcQTM=nXfRrD4-H3DXn3jaXVKqJZQF@mail.gmail.com>
References: <AANLkTingzP8Et1NcQTM=nXfRrD4-H3DXn3jaXVKqJZQF@mail.gmail.com>
Subject: Re: Use hardware snapshots to restore postgres
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.778 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, URI_HEX=1.122
X-Spam-Level: 
X-Archive-Number: 201008/270
X-Sequence-Number: 35519


http://www.tomtop.com/ China Wholesale 
http://www.tomtop.com/wireless-wifi-network-cctv-ir-waterproof-outdoor-ip-security-camera.html
Wireless IP Camera 
-- 
View this message in context: http://postgresql.1045698.n5.nabble.com/Use-hardware-snapshots-to-restore-postgres-tp2740688p2795381.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.



From scott.marlowe@gmail.com Sat Aug  28 14:28:49 2010
Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 3E270632963
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 28 Aug 2010 11:28:49 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 21382-02 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 28 Aug 2010 14:28:42 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-ww0-f42.google.com (mail-ww0-f42.google.com
 [74.125.82.42])
	by mail.postgresql.org (Postfix) with ESMTP id 0DF7C62F22C
	for <pgsql-admin@postgresql.org>; Sat, 28 Aug 2010 11:28:29 -0300 (ADT)
Received: by wwj40 with SMTP id 40so194875wwj.1
	for <pgsql-admin@postgresql.org>; Sat, 28 Aug 2010 07:28:17 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:cc:content-type
	:content-transfer-encoding;
	bh=gJDdBp4R7uFEc1R09lPpOOKGZuZGrg7ZwrJRh5TOB7s=;
	b=Ng85yHJgxxRarNkx8NTQCvVG3jMy38UQdObF4O8X9oiT2aW3tILdgQwk+pmW+ko7x0
	4+7jrDq65N2SpC3vrtGCw6gM1WPvY2gXA9g35X7f+EPyN0EziDQ1J4vd0a2pl52sPuRO
	z2SnxwugUyU3qEvqGauOlkGgzrNsuft8h8cno=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=wmran1hM7WaOpoZH2aNVPDF2oRFGwetsAPM+UYiAul2acpu+5fVqj3lHs7D7AF/eqQ
	YUODFRjMVdBMST/ENLk3lpx3KKDQtsCRwC/KoLbnMosDfcEOmu9x+xhv9epgtbFFB7zb
	9FMBqIYHeGvPzMlCXWFjYvtahWTAKpl/+ntj8=
MIME-Version: 1.0
Received: by 10.227.136.129 with SMTP id r1mr2322661wbt.114.1283005682791;
	Sat, 28 Aug 2010 07:28:02 -0700 (PDT)
Received: by 10.227.148.75 with HTTP; Sat, 28 Aug 2010 07:28:02 -0700 (PDT)
In-Reply-To: <C89D55D9.20411%jigar@aggregateknowledge.com>
References: <C89D55D9.20411%jigar@aggregateknowledge.com>
Date: Sat, 28 Aug 2010 08:28:02 -0600
Message-ID: <AANLkTikT7GHUqP7ZaLB5CF61SNQbgJN0HRi+opRKQv=L@mail.gmail.com>
Subject: Re: Use hardware snapshots to restore postgres
From: Scott Marlowe <scott.marlowe@gmail.com>
To: jigar shah <jigar@aggregateknowledge.com>
Cc: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201008/264
X-Sequence-Number: 35513

On Fri, Aug 27, 2010 at 12:45 PM, jigar shah
<jigar@aggregateknowledge.com> wrote:
> Postgres Guru=92s
>
> Do you guys know the procedure to use hardware snapshots (for eg 3par) to
> restore postgres database? Is there somewhere I can find good documentati=
on
> to do this?
>

Did you even read the section of the docs on this I suggested?

http://www.postgresql.org/docs/8.4/interactive/continuous-archiving.html



From scott.marlowe@gmail.com Sun Aug  29 00:29:32 2010
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 348B7634C48
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 28 Aug 2010 21:29:32 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 16480-09 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun, 29 Aug 2010 00:29:23 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com
	[74.125.82.174])
	by mail.postgresql.org (Postfix) with ESMTP id C9955634C5F
	for <pgsql-admin@postgresql.org>; Sat, 28 Aug 2010 21:29:24 -0300 (ADT)
Received: by wyb35 with SMTP id 35so5281830wyb.19
	for <pgsql-admin@postgresql.org>; Sat, 28 Aug 2010 17:29:22 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:cc:content-type
	:content-transfer-encoding;
	bh=idMOYTHxTTzFW4fq1SlVgnfo6ozugAk42Sg45frdGCE=;
	b=TT3C794iI+CFJEvO+ThtNlEaVdHqP4SbV4z7TDe311xrN+3RTWLR/4wZkW3soK0W4K
	UoQGAw1IKDkIZDd6fW2xZFrj2dIfiIdZu2mwMtaIFXXvTcB1zZ+rBk9vS+s6xoKDWjni
	dNYoT70L4MEKrLBblYs3T9Qt0QtROjR5Y1Z+I=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=Rj+kYnq5ArKHmnWk7w8/vEUUcX58Zh9U9JNunKDsA7MB7B1ID94z9uwGPFFqnZE2Ci
	I2f14HHXCWfqAfjCBXdHts33FuyBt510HFzPxAwaGeA5DU+fOLjShbbtfIAuD3w9T892
	jIXvbDwD61F+UWDiURrK8X86H/VpME0KKhmPw=
MIME-Version: 1.0
Received: by 10.227.133.18 with SMTP id d18mr2919257wbt.33.1283041762633; Sat,
	28 Aug 2010 17:29:22 -0700 (PDT)
Received: by 10.227.148.75 with HTTP; Sat, 28 Aug 2010 17:29:22 -0700 (PDT)
In-Reply-To: <AANLkTim4hj_nKixQMHCqDDH+2vkugHeW-pf4Hv4kHs9a@mail.gmail.com>
References: <AANLkTingzP8Et1NcQTM=nXfRrD4-H3DXn3jaXVKqJZQF@mail.gmail.com>
	<AANLkTim4hj_nKixQMHCqDDH+2vkugHeW-pf4Hv4kHs9a@mail.gmail.com>
Date: Sat, 28 Aug 2010 18:29:22 -0600
Message-ID: <AANLkTimNe5sqy8wrUT_cNhXxak1cAVnOz=ZkOk8R5ktz@mail.gmail.com>
Subject: Re: Use hardware snapshots to restore postgres
From: Scott Marlowe <scott.marlowe@gmail.com>
To: jigar shah <jshah1982@gmail.com>
Cc: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201008/271
X-Sequence-Number: 35520

On Sat, Aug 28, 2010 at 12:24 AM, Scott Marlowe <scott.marlowe@gmail.com> w=
rote:
> On Fri, Aug 27, 2010 at 7:57 PM, jigar shah <jshah1982@gmail.com> wrote:
>> =A0Postgres Guru=92s
>>
>> Do you guys know the procedure to use hardware snapshots (for eg 3par) t=
o
>> restore postgres database? Is there somewhere I can find good documentat=
ion
>> to do this?
>
> http://www.postgresql.org/docs/8.4/interactive/continuous-archiving.html
>
> is a good place to start.

Specifically this section:

24.3.2. Making a Base Backup



From jshah1982@gmail.com Sun Aug  29 01:15:38 2010
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id A762B6323DE
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 28 Aug 2010 22:15:38 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 06450-08 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun, 29 Aug 2010 01:15:29 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com
	[74.125.82.174])
	by mail.postgresql.org (Postfix) with ESMTP id D6D3C632C66
	for <pgsql-admin@postgresql.org>; Sat, 28 Aug 2010 22:15:30 -0300 (ADT)
Received: by wyb35 with SMTP id 35so5308533wyb.19
	for <pgsql-admin@postgresql.org>; Sat, 28 Aug 2010 18:15:28 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:cc:content-type;
	bh=VQa+pMqRPekR6NoBOM/mPALD9IIJBGRInRKh/zWWKuI=;
	b=v/3ODLdkTDtTLk+WpB1xCD8H6aAgBlOzuYUWqWN/cD2Ax7WqAXGFVKNrML6Wtc0dpo
	sOpv1uKpXSCpNxA962Yu5yOg/pKxpwVfV5E6LxtRX9+h3XCE4HUGT91H1CdI9M+UzTR4
	cFbDW96Ukv5VsPHQpJMPyZ2nOohBhzO3WwCTo=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=SUqJwfM+WvLw5AihB5CLbr1eVB6W+rKeF2IeI/eJCvhWPkz1X/3rSza+tdn5iWGkti
	CK59PPnTomh0zyGQTWKMUFbfS/ZhweeA0hyagnEy2tPbluVeMGIIPA1oVpUywsna6Btf
	O+HVoOutEazMVGHCNUGY7cifKSgSmkybgu3m4=
MIME-Version: 1.0
Received: by 10.227.155.135 with SMTP id s7mr2930211wbw.100.1283044528557;
	Sat, 28 Aug 2010 18:15:28 -0700 (PDT)
Received: by 10.227.136.209 with HTTP; Sat, 28 Aug 2010 18:15:28 -0700 (PDT)
In-Reply-To: <AANLkTimNe5sqy8wrUT_cNhXxak1cAVnOz=ZkOk8R5ktz@mail.gmail.com>
References: <AANLkTingzP8Et1NcQTM=nXfRrD4-H3DXn3jaXVKqJZQF@mail.gmail.com>
	<AANLkTim4hj_nKixQMHCqDDH+2vkugHeW-pf4Hv4kHs9a@mail.gmail.com>
	<AANLkTimNe5sqy8wrUT_cNhXxak1cAVnOz=ZkOk8R5ktz@mail.gmail.com>
Date: Sat, 28 Aug 2010 18:15:28 -0700
Message-ID: <AANLkTikT-bHe+g7h7p635_hVGpe4URBnzH+ES+0U+jdm@mail.gmail.com>
Subject: Re: Use hardware snapshots to restore postgres
From: jigar shah <jshah1982@gmail.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary=0016e659f4d85b135b048eec1512
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201008/272
X-Sequence-Number: 35521

--0016e659f4d85b135b048eec1512
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

thanks Scott. i have read and used this article a lot of times before.

in section 24.3.2, step number 3 says

"3. Perform the backup, using any convenient file-system-backup tool such a=
s
tar or cpio. It is neither necessary nor desirable to stop normal operation
of the database while you do this. "

so instead of tar or cpio, i am looking for the procedure where you can use
hardware level snapshots of the postgres filesystem, which you can take on
san (3par) or nas (netapp) or any other vendor hardware, and then mount the
postgres filesystem snapshot to a different host.

i know a lot of ppl use this procedure, but cant find a good doc for this
procedure.

regards
Jigar

On Sat, Aug 28, 2010 at 5:29 PM, Scott Marlowe <scott.marlowe@gmail.com>wro=
te:

> On Sat, Aug 28, 2010 at 12:24 AM, Scott Marlowe <scott.marlowe@gmail.com>
> wrote:
> > On Fri, Aug 27, 2010 at 7:57 PM, jigar shah <jshah1982@gmail.com> wrote=
:
> >>  Postgres Guru=92s
> >>
> >> Do you guys know the procedure to use hardware snapshots (for eg 3par)
> to
> >> restore postgres database? Is there somewhere I can find good
> documentation
> >> to do this?
> >
> > http://www.postgresql.org/docs/8.4/interactive/continuous-archiving.htm=
l
> >
> > is a good place to start.
>
> Specifically this section:
>
> 24.3.2. Making a Base Backup
>



--=20
"luck is truly where preparation meets opportunity"
--Randy Pausch

--0016e659f4d85b135b048eec1512
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

thanks Scott. i have read and used this article a lot of times before.<br><=
br>in section 24.3.2, step number 3 says<br><br>&quot;3. Perform the backup=
, using any convenient file-system-backup tool      such as <span class=3D"=
APPLICATION">tar</span> or <span class=3D"APPLICATION">cpio</span>.  It is =
neither      necessary nor desirable to stop normal operation of the databa=
se      while you do this.     &quot;<br>
<br>so instead of tar or cpio, i am looking for the procedure where you can=
 use hardware level snapshots of the postgres filesystem, which you can tak=
e on san (3par) or nas (netapp) or any other vendor hardware, and then moun=
t the postgres filesystem snapshot to a different host. <br>
<br>i know a lot of ppl use this procedure, but cant find a good doc for th=
is procedure.<br><br>regards<br>Jigar<br><br><div class=3D"gmail_quote">On =
Sat, Aug 28, 2010 at 5:29 PM, Scott Marlowe <span dir=3D"ltr">&lt;<a href=
=3D"mailto:scott.marlowe@gmail.com">scott.marlowe@gmail.com</a>&gt;</span> =
wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin: 0pt 0pt 0pt 0.8ex; borde=
r-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div><div></div><=
div class=3D"h5">On Sat, Aug 28, 2010 at 12:24 AM, Scott Marlowe &lt;<a hre=
f=3D"mailto:scott.marlowe@gmail.com">scott.marlowe@gmail.com</a>&gt; wrote:=
<br>

&gt; On Fri, Aug 27, 2010 at 7:57 PM, jigar shah &lt;<a href=3D"mailto:jsha=
h1982@gmail.com">jshah1982@gmail.com</a>&gt; wrote:<br>
&gt;&gt; =A0Postgres Guru=92s<br>
&gt;&gt;<br>
&gt;&gt; Do you guys know the procedure to use hardware snapshots (for eg 3=
par) to<br>
&gt;&gt; restore postgres database? Is there somewhere I can find good docu=
mentation<br>
&gt;&gt; to do this?<br>
&gt;<br>
&gt; <a href=3D"http://www.postgresql.org/docs/8.4/interactive/continuous-a=
rchiving.html" target=3D"_blank">http://www.postgresql.org/docs/8.4/interac=
tive/continuous-archiving.html</a><br>
&gt;<br>
&gt; is a good place to start.<br>
<br>
</div></div>Specifically this section:<br>
<br>
24.3.2. Making a Base Backup<br>
</blockquote></div><br><br clear=3D"all"><br>-- <br>&quot;luck is truly whe=
re preparation meets opportunity&quot;<br>--Randy Pausch<br>

--0016e659f4d85b135b048eec1512--



From scott.marlowe@gmail.com Sun Aug  29 02:05:22 2010
Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 8BB98632B88
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 28 Aug 2010 23:05:22 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 64373-06 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun, 29 Aug 2010 02:05:15 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-ww0-f42.google.com (mail-ww0-f42.google.com
 [74.125.82.42])
	by mail.postgresql.org (Postfix) with ESMTP id 12753632722
	for <pgsql-admin@postgresql.org>; Sat, 28 Aug 2010 23:05:14 -0300 (ADT)
Received: by wwj40 with SMTP id 40so756007wwj.1
	for <pgsql-admin@postgresql.org>; Sat, 28 Aug 2010 19:05:12 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:cc:content-type;
	bh=HIxqA9dUapeOiESg14ShazxF2+kEi6RzHLzT6d+F5XE=;
	b=winSwgAUAQFLdnEMgx4P5TX7cMBkT9O6hYbpiUXpOW9ZlVXc9rLNCZ6ZKi5pExW5vW
	jhxwpEUweDK08cxLfMlVTzJV1NtXat6Taz0q6UO4HdclfX/igxw/x05L//Ivu/YECQyU
	NIQPYWn03SK3yyuCBXzS8JcDC1uGqEUrMdlA0=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=q8hTPFh2s3VR2TRjVPZvDk8aYD55KBFvjgrqSKNaF5gqDJIRyj36HaGW5izx22+U4L
	lLKhL9DVupErAX4wYTCaE2yuPaytYGI3V+b1MmTisLB18dq5Kvgkv9zWgUdKAnZhejmL
	gRFld4Zti4U8tYk53Lh96gD6rrlGAoVnu4ozU=
MIME-Version: 1.0
Received: by 10.227.133.18 with SMTP id d18mr2996253wbt.33.1283047512826; Sat,
	28 Aug 2010 19:05:12 -0700 (PDT)
Received: by 10.227.148.75 with HTTP; Sat, 28 Aug 2010 19:05:12 -0700 (PDT)
In-Reply-To: <AANLkTikT-bHe+g7h7p635_hVGpe4URBnzH+ES+0U+jdm@mail.gmail.com>
References: <AANLkTingzP8Et1NcQTM=nXfRrD4-H3DXn3jaXVKqJZQF@mail.gmail.com>
	<AANLkTim4hj_nKixQMHCqDDH+2vkugHeW-pf4Hv4kHs9a@mail.gmail.com>
	<AANLkTimNe5sqy8wrUT_cNhXxak1cAVnOz=ZkOk8R5ktz@mail.gmail.com>
	<AANLkTikT-bHe+g7h7p635_hVGpe4URBnzH+ES+0U+jdm@mail.gmail.com>
Date: Sat, 28 Aug 2010 20:05:12 -0600
Message-ID: <AANLkTinHMA2++4MfLO1WjUoCk9u-Q8NqmH=8MoYMxOsX@mail.gmail.com>
Subject: Re: Use hardware snapshots to restore postgres
From: Scott Marlowe <scott.marlowe@gmail.com>
To: jigar shah <jshah1982@gmail.com>
Cc: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201008/273
X-Sequence-Number: 35522

On Sat, Aug 28, 2010 at 7:15 PM, jigar shah <jshah1982@gmail.com> wrote:
> thanks Scott. i have read and used this article a lot of times before.
>
> in section 24.3.2, step number 3 says
>
> "3. Perform the backup, using any convenient file-system-backup tool such as
> tar or cpio. It is neither necessary nor desirable to stop normal operation
> of the database while you do this. "
>
> so instead of tar or cpio, i am looking for the procedure where you can use
> hardware level snapshots of the postgres filesystem, which you can take on
> san (3par) or nas (netapp) or any other vendor hardware, and then mount the
> postgres filesystem snapshot to a different host.
>
> i know a lot of ppl use this procedure, but cant find a good doc for this
> procedure.

I found little on the google about snapshotting with 3par.  I'd guess
they gave you docs on how to do that.  I hope.  I found plenty on
doing it with other file systems / etc, like LVM, ZFS, Microsoft, EMC.

For 3par I searched google for "3par snapshot howto" and the first
result was a pdf that seems to show what to do, but doesn't feel like
definitive documentation.  They're big on marketing, not so much on
documentation it seems.

-- 
To understand recursion, one must first understand recursion.



From rosser.schwarz@gmail.com Sun Aug  29 17:21:20 2010
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id C6DBA632B10
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun, 29 Aug 2010 14:21:20 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 68107-08 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun, 29 Aug 2010 17:21:13 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-ww0-f50.google.com (mail-ww0-f50.google.com
 [74.125.82.50])
	by mail.postgresql.org (Postfix) with ESMTP id 67CDE632785
	for <pgsql-admin@postgresql.org>; Sun, 29 Aug 2010 14:21:13 -0300 (ADT)
Received: by wwb34 with SMTP id 34so4087263wwb.19
	for <pgsql-admin@postgresql.org>; Sun, 29 Aug 2010 10:21:12 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:cc:content-type;
	bh=d6i1JJY9hC8CEX6sH23bJKX61WiEFvNz9VMXJyEGox8=;
	b=ZgOFmVwR6DyqmgLZscz/F1rmMqO2+BZDQvTZCvwXqnFfeqx7qwjkbyBVfl9lr1wv9j
	Tf6B3NRmYDKGdozUy/mtp7Db4dI6gdF7OOl5ng0RuGMl3njz792eL8qcE/74f7PaD4G4
	tH6dH5Q9pccs4xIw4peoPwZ550+tAU+1kkp4M=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=ITxZnQ6VYo3bl/BvtgsMrJfEEwlVgBoNgcZldKJJ7nLDhb0sP0yqbhidqeHoedn+Cc
	eUHEoeVgmYm1BxZNy86ylnok83EKM9FrqTXQttReCgUQ7Erqyz7bsZvt/wdu9hD1h2/j
	dE8DugodIMIls7YMs4gKt6HdAffB4orvzxM1s=
MIME-Version: 1.0
Received: by 10.227.134.129 with SMTP id j1mr3575798wbt.79.1283102472033; Sun,
	29 Aug 2010 10:21:12 -0700 (PDT)
Received: by 10.216.180.143 with HTTP; Sun, 29 Aug 2010 10:21:11 -0700 (PDT)
In-Reply-To: <AANLkTikT-bHe+g7h7p635_hVGpe4URBnzH+ES+0U+jdm@mail.gmail.com>
References: <AANLkTingzP8Et1NcQTM=nXfRrD4-H3DXn3jaXVKqJZQF@mail.gmail.com>
	<AANLkTim4hj_nKixQMHCqDDH+2vkugHeW-pf4Hv4kHs9a@mail.gmail.com>
	<AANLkTimNe5sqy8wrUT_cNhXxak1cAVnOz=ZkOk8R5ktz@mail.gmail.com>
	<AANLkTikT-bHe+g7h7p635_hVGpe4URBnzH+ES+0U+jdm@mail.gmail.com>
Date: Sun, 29 Aug 2010 11:21:11 -0600
Message-ID: <AANLkTi=Z=kL2-xVwHD46b_EFGJ_hpx2mZPQi_-n8cpNA@mail.gmail.com>
Subject: Re: Use hardware snapshots to restore postgres
From: Rosser Schwarz <rosser.schwarz@gmail.com>
To: jigar shah <jshah1982@gmail.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>, pgsql-admin@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201008/275
X-Sequence-Number: 35524

On Sat, Aug 28, 2010 at 7:15 PM, jigar shah <jshah1982@gmail.com> wrote:
> so instead of tar or cpio, i am looking for the procedure where you can use
> hardware level snapshots of the postgres filesystem, which you can take on
> san (3par) or nas (netapp) or any other vendor hardware, and then mount the
> postgres filesystem snapshot to a different host.

I've used this technique on NetApp filers quite a bit.  The critical
step is to issue a CHECKPOINT (and allow time for it to settle,
depending on your checkpoint_completion_target setting) *before*
taking the snapshot.  When you mount the snap elsewhere and start up
another postmaster, it will take a moment to clean up (to the postgres
cluster running against the snap, it will appear as if there was an
unclean shutdown), and you're good to go.

Remember also to synchronize snapping your data and WAL filesystems as
much as possible, if you're using separate volumes for them (as we
did).

I routinely used this technique to populate development and testing
environments, as well as to spin up a secondary instance to use for
backups (i.e., pg_dump), to avoid impacting the production environment
with that IO overhead.

rls

-- 
:wq