Thanks karsten. Anybody have production setup with diff database in diff folder ie) diff partition. Please provide the details if possible help me with diaghram. Regards Karthikeyan.N -----Original Message----- From: Karsten Hilbert [mailto:Karsten.Hilbert@xxxxxxx] Sent: Thursday, March 12, 2009 4:46 PM To: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Database separation for backup 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
