Delete database older than 2 years

[CherryWaves]

Hello,

I want to delete everything in my database except for the last 2 years. I want to clear up space on my Desktop.

How can I do this?

Thank you

[CherryWaves]

Part 2 of my question:

I want to create a new databse and have the hands saved to an alternative drive. Is this possible? How can I do that?

Cheers

[Flag_Hippo]

I want to delete everything in my database except for the last 2 years. I want to clear up space on my Desktop.

How can I do this?

You can create a new database, import the hands you want there and delete the original database:

Guide: Creating A New Database in PokerTracker 4

Guide: Database Management

If you want to keep player/hand notes then you will need to export those from the original database (File -> Notes).

If you have manually entered tournament data you can export those tournaments from the original database:

Guide: Exporting Hands

Note if you have marked/tagged hands then they are stored in the database and cannot be transferred if you are reimporting.

Part 2 of my question:

I want to create a new databse and have the hands saved to an alternative drive. Is this possible? How can I do that?

Uninstall PostgreSQL from one drive and install it to a different drive:

Guide: Uninstalling PostgreSQL

Guide: Installing PostgreSQL

If you are moving PostgreSQL to a slower drive (e.g. SSD to HDD) there will be a performance hit.