Database separation for backup

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