PDA

View Full Version : How to delete sessions via pgadmin



pds
09-24-2009, 02:57 PM
Hi, I was wondering how to purge hands from the database via pgadmin.

I want to delete hands from a certain date range, from sep1 to sep 16, is there a query code you can type to delete these?

I did try the purge hands within holdem manager but it didn't work and told me to do it via vacuum or pgadmin, i tried the vacuum but that told me to vacuum via pgadmin...

netsrak
09-24-2009, 03:08 PM
The vacuum message comes after completion of the purge so the hands should be deleted already.

Its not that easy to delete the hands manually because multiple database tables are affected. You could try to search for it in the "Custom Reports" section but i'm not sure whether you find sth. there. Another solution would be to enable the SQL Logging (LogDatabaseCommands) in the holdemmanager.config, run the purge and check the Log what is happening.

You know how to vaccum via pgadmin? If not you find it in the FAQ.

pds
09-24-2009, 03:13 PM
i can successfully vacuum a database via pgadmin and have read the FAQ on that, but i want to delete just a certain amount of hands via pgadmin as well...the purge within holdem manager just doesn't work...neither does the vacuum within holdem manager...

fozzy71
09-24-2009, 06:49 PM
You can manually delete the hands in HM.

Cash Games > Hands > All Hands > Filter for your date range:

Click [x] All to load all hands from the date range.

Right-Click > Delete All Hands in List.

pds
09-24-2009, 07:42 PM
You can manually delete the hands in HM.

Cash Games > Hands > All Hands > Filter for your date range:

Click [x] All to load all hands from the date range.

Right-Click > Delete All Hands in List.

Thanks for this - really helped!