Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M44513=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1ZYzo0-0006FW-3Z
 for pgsql-admin@arkaria.postgresql.org; Mon, 07 Sep 2015 17:02:08 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-admin-owner+M44513=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1ZYznz-00010e-BN
 for pgsql-admin@arkaria.postgresql.org; Mon, 07 Sep 2015 17:02:07 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <scott_ribe@elevated-dev.com>)
 id 1ZYzmM-0007a2-MN
 for pgsql-admin@postgresql.org; Mon, 07 Sep 2015 17:00:26 +0000
Received: from mailout.easymail.ca ([64.68.201.169])
 by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256)
 (Exim 4.84) (envelope-from <scott_ribe@elevated-dev.com>)
 id 1ZYzmE-0000kT-7H
 for pgsql-admin@postgresql.org; Mon, 07 Sep 2015 17:00:24 +0000
Received: from localhost (localhost [127.0.0.1])
 by mailout.easymail.ca (Postfix) with ESMTP id 69D37E28A;
 Mon,  7 Sep 2015 13:00:16 -0400 (EDT)
X-Virus-Scanned: Debian amavisd-new at mailout.easymail.ca
X-Spam-Flag: NO
X-Spam-Score: -3.816
X-Spam-Level: 
X-Spam-Status: No, score=-3.816 required=5 tests=[ALL_TRUSTED=-1.8,
 AWL=-0.109, BAYES_00=-2.599, DNS_FROM_AHBL_RHSBL=0.692]
Received: from mailout.easymail.ca ([127.0.0.1])
 by localhost (easymail-mailout.easydns.vpn [127.0.0.1]) (amavisd-new,
 port 10024)
 with ESMTP id Sf1QpT6dDtWz; Mon,  7 Sep 2015 13:00:16 -0400 (EDT)
Received: from [192.168.2.16] (unknown [8.39.228.5])
 (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
 (No client certificate requested)
 by mailout.easymail.ca (Postfix) with ESMTPSA id DA0CBE279;
 Mon,  7 Sep 2015 13:00:15 -0400 (EDT)
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2104\))
Subject: Re: Advise on restoring from FileSystem backup
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: <182E8934F4D0094A94B8A0E5A48B8F5A355BA88E@MX105CL01.corp.emc.com>
Date: Mon, 7 Sep 2015 11:00:13 -0600
Content-Transfer-Encoding: 7bit
Message-Id: <997E465A-FFEC-4805-BF7A-F2D8872ED96B@elevated-dev.com>
References: <182E8934F4D0094A94B8A0E5A48B8F5A355BA776@MX105CL01.corp.emc.com>
 <F4A0026B-12BF-4463-B327-E42A561FEC30@elevated-dev.com>
 <182E8934F4D0094A94B8A0E5A48B8F5A355BA88E@MX105CL01.corp.emc.com>
To: "Porwal, Utkarsh" <utkarsh.porwal@emc.com>,
 pgsql-admin <pgsql-admin@postgresql.org>
X-Mailer: Apple Mail (2.2104)
X-Pg-Spam-Score: -2.6 (--)
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

On Sep 7, 2015, at 10:55 AM, Porwal, Utkarsh <utkarsh.porwal@emc.com> wrote:
> 
> But the filesystem backup should work, isn't it?

Yes, if:

- You've actually stopped the db when you think you have.
- You've actually correctly copied the data directory.
- Nothing mysterious was modifying the data while you were copying it.

-- 
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice







-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin