Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B32F964FC4F for ; Wed, 10 Dec 2008 10:15:34 -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 36433-08-2 for ; Wed, 10 Dec 2008 10:15:30 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.168]) by mail.postgresql.org (Postfix) with ESMTP id 143A96501BE for ; Wed, 10 Dec 2008 10:15:29 -0400 (AST) Received: by wf-out-1314.google.com with SMTP id 25so172337wfc.28 for ; Wed, 10 Dec 2008 06:15:27 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=hPhv9cvXgTDBH7XYQEdKymQ93c51srXQcOulme4r5b0=; b=t1Klqbu5kXYgqEH8clnBwexSC6uySkyg3tIYvwETM0YFrVGd3kN2082QD4TMshPGun YOjaq8z7o4YoBwu34LDnda0DKpyNaaAivgCUpITAVYLJda5jnqYihcXpSIZ+lPxUw9EL jhvjifVyQaGoe01R/r6Z+VA4tLMu7VkSCfoSo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=VwlcXXHkbzlZcgzwkRUafEZsk0ruPUonS5q0chvbs/JvuVHFERbk9o9qocD7jMQCrz GoarYcXW/9n6kXLWfh1uX76lS+wsqjiI8rQASId1AWZFB9AVQAqyytWMVqcQDsqrAT/n JhQwCuKHD9phRG/bjWFpauZxFN6HBg7puUqvU= Received: by 10.114.211.1 with SMTP id j1mr967624wag.176.1228918527001; Wed, 10 Dec 2008 06:15:27 -0800 (PST) Received: by 10.114.167.5 with HTTP; Wed, 10 Dec 2008 06:15:26 -0800 (PST) Message-ID: Date: Wed, 10 Dec 2008 07:15:26 -0700 From: "Scott Marlowe" To: "Michael Leshchenko" Subject: Re: File system level backup with more than one cluster folders Cc: pgsql-admin@postgresql.org In-Reply-To: <493F6F40.9060906@its.fh-giessen.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <493F6F40.9060906@its.fh-giessen.de> 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/95 X-Sequence-Number: 30928 On Wed, Dec 10, 2008 at 12:26 AM, Michael Leshchenko wrote: > Dear pg community > > 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. Quick question, why? If you really need it, you need to shutdown pgsql and then run the file system backup of all the directories that pg uses. But a pg_dumpall is a much better way to take a backup.