GiedriusZ
09-16-2011, 07:20 AM
Hello.
I had about 7kk hands in my database and my HEM was getting slow and it took a whole bunch of space so i purged the hands that i wasn't involved in. I have ~60k players in my database and I was wondering, is it possible to export the database without the actual hands and preserve other player stats?
I need to re-install Windows really bad and don't want to loose the player stats and notes I have on them.
All the tutorials I've read in the FAQ involves exporting HH's and re-importing them again. Is there a way to export the database through PSQL?
EDIT: I found in pgAdmin3 that you can backup any database to a file and then restore it. Can I backup my DB that way and after i re-install Windows, restore it from the backup file and make HEM use that DB? Will it have all the hands I haven't purged yet and all the player stats and notes on it?
I had about 7kk hands in my database and my HEM was getting slow and it took a whole bunch of space so i purged the hands that i wasn't involved in. I have ~60k players in my database and I was wondering, is it possible to export the database without the actual hands and preserve other player stats?
I need to re-install Windows really bad and don't want to loose the player stats and notes I have on them.
All the tutorials I've read in the FAQ involves exporting HH's and re-importing them again. Is there a way to export the database through PSQL?
EDIT: I found in pgAdmin3 that you can backup any database to a file and then restore it. Can I backup my DB that way and after i re-install Windows, restore it from the backup file and make HEM use that DB? Will it have all the hands I haven't purged yet and all the player stats and notes on it?