Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 572FC63295F;
	Thu, 12 Mar 2009 08:06:04 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 91440-03; Thu, 12 Mar 2009 08:05:55 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail2.Synechron.com (mail2.synechron.com [220.225.40.41])
	by mail.postgresql.org (Postfix) with ESMTP id A60AC6328B2;
	Thu, 12 Mar 2009 08:05:53 -0300 (ADT)
Received: from [10.31.15.20] [10.31.15.20] by mail2.Synechron.com with ESMTP
	(SMTPD-9.10) id ACB6307F00; Thu, 12 Mar 2009 16:36:30 +0530
Message-ID: <49B8EC8B.3030107@synechron.com>
Date: Thu, 12 Mar 2009 16:35:47 +0530
From: Ashish Karalkar <ashishka@synechron.com>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
To: "Nagalingam, Karthikeyan" <KARTHIKEYAN.Nagalingam@netapp.com>
CC: pgsql-admin@postgresql.org, pgsql-general@postgresql.org
Subject: Re: [GENERAL] Database separation for backup
References: 
 <5FFF8E9361C5D84EBBAF70C1931CDDE303D6C299@BTCMVEXC1-PRD.hq.netapp.com>
In-Reply-To: 
 <5FFF8E9361C5D84EBBAF70C1931CDDE303D6C299@BTCMVEXC1-PRD.hq.netapp.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.216 tagged_above=0 required=5 tests=AWL=-1.216,
	DNS_FROM_OPENWHOIS=2.431
X-Spam-Level: *
X-Archive-Number: 200903/149
X-Sequence-Number: 31649

Nagalingam, Karthikeyan wrote:
> Hi,
>  
> Is there any way to keep each database in separate partition ie) 
> separate folder for each database.
>  
> I would like to do the dabase level backup in storage side, for that 
> If I am able to separate the database in folderwise, I can allocate 
> separate partition for each database. Then I can take the backup in 
> each partition.
>  
> Your recommendation and suggestion are welcome.
>  
> Regards
> Karthikeyan.N
>  
>  
I guess tablespace will be of  your use and also you can directly use  
softlink to link database directory in data/base<databaseoid>  to the 
desired folder.


With Regards
--Ashish