In response to S Arvind : > 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.
Don't understand ... > 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 Sure, use different tablespaces. http://www.postgresql.org/docs/8.4/static/manage-ag-tablespaces.html Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
