PDA

View Full Version : Can I have databases on different Hard or flash drives?



hmo7
09-29-2010, 11:38 PM
Could not find an answer in forums.
I have a 128GB SSD for my system+HM+Postgres. I keep running into a problem of low disk space every two weeks (default DB grows fast). I do purge/vacuum every 2 weeks. There is a couple of DBs which I don't use often, but would like to have a look at them from time to time (including hands replay, etc.). If I move them, it'll free up the space I need. Speed in this case is not an issue.
Is it possible to move couple of DBs (or create new DBs) to an external USB hard or flash drive and use with HM when I need them?

netsrak
09-30-2010, 04:20 AM
It is possible but....

Its a postgresql function - you need to create additional table spaces on the other partitions and create the databases in this table space.
This is something we can't support here so i suggest you search the postgresql documentation (PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)).