Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id A6F9B64FC57 for ; Wed, 10 Dec 2008 06:13:13 -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 93070-04 for ; Wed, 10 Dec 2008 06:13:08 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by mail.postgresql.org (Postfix) with ESMTP id 5177A64FC4C for ; Wed, 10 Dec 2008 06:13:08 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id BA11E470013 for ; Wed, 10 Dec 2008 11:13:04 +0100 (CET) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id dBkffWK34W9I for ; Wed, 10 Dec 2008 11:13:04 +0100 (CET) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id A8900470007; Wed, 10 Dec 2008 11:13:04 +0100 (CET) Date: Wed, 10 Dec 2008 11:13:04 +0100 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: File system level backup with more than one cluster folders Message-ID: <20081210101304.GB21211@easy2.in-chemnitz.de> References: <493F6F40.9060906@its.fh-giessen.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <493F6F40.9060906@its.fh-giessen.de> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/89 X-Sequence-Number: 30922 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 You need to backup any file system structure belonging to your PG database. HTH, Tino. -- "What we nourish flourishes." - "Was wir nähren erblüht." www.lichtkreis-chemnitz.de www.craniosacralzentrum.de