Jasen Betts wrote: > On 2009-09-03, S Arvind <arvindwill@xxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
