Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 452B764FE0F
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 11 Dec 2008 08:04:44 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 73121-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 11 Dec 2008 08:04:37 -0400 (AST)
X-Greylist: delayed 00:05:36.985608 by SQLgrey-1.7.6
Received: from rv-out-0506.google.com (rv-out-0506.google.com
 [209.85.198.233])
	by mail.postgresql.org (Postfix) with ESMTP id 27B1564FECD
	for <pgsql-admin@postgresql.org>; Thu, 11 Dec 2008 08:04:36 -0400 (AST)
Received: by rv-out-0506.google.com with SMTP id b25so829152rvf.43
	for <pgsql-admin@postgresql.org>; Thu, 11 Dec 2008 04:04:34 -0800 (PST)
Received: by 10.141.88.3 with SMTP id q3mr1230151rvl.229.1228996735744;
	Thu, 11 Dec 2008 03:58:55 -0800 (PST)
Received: by 10.140.134.11 with HTTP; Thu, 11 Dec 2008 03:58:55 -0800 (PST)
Message-ID: <f6fdfb550812110358q4dc40063vd79e355805e63523@mail.gmail.com>
Date: Thu, 11 Dec 2008 14:58:55 +0300
From: "Vladimir Rusinov" <vladimir@greenmice.info>
To: pgsql-admin@postgresql.org
Subject: Re: File system level backup with more than one cluster folders
In-Reply-To: <20081210101304.GB21211@easy2.in-chemnitz.de>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_82201_15930899.1228996735738"
References: <493F6F40.9060906@its.fh-giessen.de>
	<20081210101304.GB21211@easy2.in-chemnitz.de>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200812/97
X-Sequence-Number: 30930

------=_Part_82201_15930899.1228996735738
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Wed, Dec 10, 2008 at 1:13 PM, Tino Schwarze <postgresql@tisc.de> wrote:

> Hi Mike,
>
> > I am newbie with PostgreSQL. I have separate table space for my
> > databases, which is located in separate folder, which is different to
> > default. I would like to carry out file system level backup.  Do I need
> > to backup only folder with my table space or all pg folders.
>
> Do you know that a file system level backup is only useful if
>
> a) the postgres instance is stopped
> or
> b) your are using WAL archiving and have an appropiate setup to tell PG
>   about backup starts and ends


c) your are using lvm (or zfs) snapshots and know that postgres would run
recovery after backup restore.

-- 
Vladimir Rusinov
http://greenmice.info/

------=_Part_82201_15930899.1228996735738
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<br><br> <br><br><div class="gmail_quote">On Wed, Dec 10, 2008 at 1:13 PM, Tino Schwarze <span dir="ltr">&lt;<a href="mailto:postgresql@tisc.de">postgresql@tisc.de</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Mike,<br>
<div class="Ih2E3d"><br>
&gt; I am newbie with PostgreSQL. I have separate table space for my<br>
&gt; databases, which is located in separate folder, which is different to<br>
&gt; default. I would like to carry out file system level backup. &nbsp;Do I need<br>
&gt; to backup only folder with my table space or all pg folders.<br>
<br>
</div>Do you know that a file system level backup is only useful if<br>
<br>
a) the postgres instance is stopped<br>
or<br>
b) your are using WAL archiving and have an appropiate setup to tell PG<br>
 &nbsp; about backup starts and ends</blockquote><div><br>c) your are using lvm (or zfs) snapshots and know that postgres would run recovery after backup restore.<br></div></div><br>-- <br>Vladimir Rusinov<br><a href="http://greenmice.info/">http://greenmice.info/</a><br>


------=_Part_82201_15930899.1228996735738--