Thread: Database separation for backup
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
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
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
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@gmx.net] Sent: Thursday, March 12, 2009 4:46 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general