Does PostgreSQL supports multiple data files?


I want to know if PostgreSQL supports multiple data files. Can I have database tables in different data files so that when I back up the database, I back up the different data files instead of backing up the entire database at once?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

theGhost_k8Database ConsultantCommented:
You can take dump using pg_dump of full database by specifying only  "dbname" or to backup only table you can specify "dbame -t tablename"
vielkacarolina1239Author Commented:
But, what about having different Data files. Is this possible.  The second reason I wanted to have multiple data files is because I want to create different hard drive array configurations. One hd array will contain disks running at 10k and a second array will contain disks running at 15k. I wanted to have the must utilized tables on the 15k hd array and the other less used tables on the 10k hd array. This is why I wanted to create different Data files. One data file for each hd array configuration - in this case, two hd arrays.

well, as-much as i know, it's possible to store tables in many different locations using table spaces or how its called.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vielkacarolina1239Author Commented:
thanks, this is exactly what I needed.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.