Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id D8B81632998 for ; Thu, 12 Mar 2009 08:15:50 -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 93773-06 for ; Thu, 12 Mar 2009 08:15:42 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by mail.postgresql.org (Postfix) with SMTP id D50A163295F for ; Thu, 12 Mar 2009 08:15:47 -0300 (ADT) Received: (qmail invoked by alias); 12 Mar 2009 11:15:44 -0000 Received: from L7325.l.strato-dslnet.de (EHLO merkur.hilbert.loc) [89.48.115.37] by mail.gmx.net (mp026) with SMTP; 12 Mar 2009 12:15:44 +0100 X-Authenticated: #1433807 X-Provags-ID: V01U2FsdGVkX1+RoWhcP4yROZrf4TzPzIhWGVEuPl3xvXQ+jKfcEI tv9SvDyTxgN8+O Received: from ncq by merkur.hilbert.loc with local (Exim 4.69) (envelope-from ) id 1Lhit4-00020d-Hl for pgsql-general@postgresql.org; Thu, 12 Mar 2009 12:15:42 +0100 Date: Thu, 12 Mar 2009 12:15:42 +0100 From: Karsten Hilbert To: pgsql-general@postgresql.org Subject: Re: Database separation for backup Message-ID: <20090312111542.GA3965@merkur.hilbert.loc> Mail-Followup-To: pgsql-general@postgresql.org References: <5FFF8E9361C5D84EBBAF70C1931CDDE303D6C299@BTCMVEXC1-PRD.hq.netapp.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5FFF8E9361C5D84EBBAF70C1931CDDE303D6C299@BTCMVEXC1-PRD.hq.netapp.com> User-Agent: Mutt/1.5.18 (2008-05-17) X-Y-GMX-Trusted: 0 X-FuHaFi: 0.73 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: 200903/459 X-Sequence-Number: 145045 On Thu, Mar 12, 2009 at 04:18:50PM +0530, Nagalingam, Karthikeyan wrote: > 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. You can use tablespaces to separate things on disk but it won't make taking filesystem level backups as easy as you might hope. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346