Partitioning Scheme for DB server
I am getting rid of Vista (p.i.a.) and converting the computer to a single boot Linux database server.
I have 1TB of HD space (2 500GB HDs) and plan to use Postgresql as a large database for a personal application (large stock and options db). The app will be a combination of Java (for the web application) and C/C++ for number crunching.
I also plan to have a small MySQL db for testing and learning PHP web applications and to prototype my Drupal website.
I'm wondering what type of partitioning scheme I should have here. I don't need that large a space for the MySQL DB, PHP/Drupal/Apache/Tomcat and other apps (I figure about 100GB for that total), but the main and DB might get spread across two HD's.
1) Where does the data reside in a Postgresql database... I mean what directory /var or what?
2) What is the usual place one puts a /www directory
3) About how large should I make those directories and can one spread a Postgresql db across multiple HD's?
I appreciate any help.
- Boredom is a personal defect.