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)