Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 843216326AB for ; 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 ; 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 ; 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 ; 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 ; 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 To: Message-ID: 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 Use hardware snapshots to restore postgres Postgres Guru’s

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?

I’d 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--