Postgres Pro
Downloads
Home   >   mailing lists

Re: Data folder in differnet filesystem - Mailing list pgsql-general

From Jasen Betts
Subject Re: Data folder in differnet filesystem
Date
Msg-id h82pk0$dpv$7@reversiblemaps.ath.cx
Whole thread Raw
In response to Data folder in differnet filesystem  (S Arvind <arvindwill@gmail.com>)
Responses Re: Data folder in differnet filesystem  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Tree view 
On 2009-09-03, S Arvind <arvindwill@gmail.com> wrote:
> --001636ed7465170dcf0472ab404d
> Content-Type: text/plain; charset=ISO-8859-1
>
> I have 2 doubts related to Filsesytem and Postgres data folder
>
> 1.Currently in CentOS,  our postgres data folder is in single filesystem. Is
> there any possibility to have a single data folder of single postgres in
> more then one file system.
> 2.I am having three big DB, is it possible to have a data of each DB in
> different file system. so if i want to add a DB to postgre i will mount a
> drive (filesystem ) and point that location for the postgres to use that
> space.
>   for eg
> Filesystem Mounted on
> /dev/hda3      /data/db1            for DB1
> /dev/hda4      /data/db2            for DB2
>

to be able to mount and unmount databases you will need to use
separate "clusters",

pgsql-general by date:

Previous
From: "Ow Mun Heng"
Date:
Subject: Re: trigger and returning the #of rows affected (partitioning)
Next
From: Jasen Betts
Date:
Subject: Re: Query and the number of row result