Re: [GENERAL] Database separation for backup

From: Ashish Karalkar <ashishka(at)synechron(dot)com>
To: "Nagalingam, Karthikeyan" <KARTHIKEYAN(dot)Nagalingam(at)netapp(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Database separation for backup
Date: 2009-03-12 11:05:47
Message-ID: 49B8EC8B.3030107@synechron.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Karsten Hilbert 2009-03-12 11:15:42 Re: Database separation for backup
Previous Message Nagalingam, Karthikeyan 2009-03-12 10:48:50 Database separation for backup

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2009-03-12 11:15:42 Re: Database separation for backup
Previous Message Nagalingam, Karthikeyan 2009-03-12 10:48:50 Database separation for backup