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

From Alvaro Herrera
Subject Re: Data folder in differnet filesystem
Date
Msg-id 20090907152506.GL8894@alvh.no-ip.org
Whole thread Raw
In response to Re: Data folder in differnet filesystem  (Jasen Betts <jasen@xnet.co.nz>)
List pgsql-general
Jasen Betts wrote:
> 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",

No, you can also use tablespaces for this.  Just create a directory
inside /data/db1 (say /data/db1/ts) and then CREATE TABLESPACE ts_for_db1
LOCATION '/data/db1/ts'.  Then you can create the database in there.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: "Levan, Jerry"
Date:
Subject: Re: More Snow Leopard problems...
Next
From: Adrian Klaver
Date:
Subject: Re: More Snow Leopard problems...