Re: Database separation for backup

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(dot)Hilbert(at)gmx(dot)net]
Sent: Thursday, March 12, 2009 4:46 PM
To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org) To
make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general