How do I create new database on a different disk ?

[Romeo83]

How do I create new database on a different SSD ? I can't find anywhere where it would let me choose which of my SSD-s I create the database on.

[polk3]

How do I create new database on a different SSD ? I can't find anywhere where it would let me choose which of my SSD-s I create the database on.

PostgreSQL allows multiple clusters or tablespaces that would allow you to spread your database across multiple volumes. I don't think PokerTracker has any facility to help with this though, and I'm not sure pgAdmin is very helpful either. It's not that surprising though, since database volume management is a fairly advanced topic.

The easiest thing though is to just make sure that your PostgreSQL database is installed on a volume that has enough space for all your databases. Basic outline:

* Back up your db from PT
* Uninstall PostgreSQL
* Reinstall PostgreSQL in another location
* Restore backup from PT

[Romeo83]

thanks polk3, that worked !