Can you run and manage a database from a portable drive.

[vgjfelix]

Ok, first question. My database has 1265730 hands and is nearly 10gb. Does that sound about the right size? If not what can I do to really pin this down to a much more managable size? I have tried the vaccuming and such in the past but it has never really done a good job of slicing things down and I don't really know what parameters I should be setting to purge/reduce the size of the database.

Second question. If I can't reduce the size can I move the database to a portable hard-drive and run it from there? The faqs seem unclear in that I would have to install postgresql to a new drive, but could I put it on a portable drive and run it like that.

Don't have any other real options as my laptop hard drive is full.

Thanks in advance

[morny]

See this thread for reclaiming space http://www.holdemmanager.net/forum/s...2648#post32648

You could also transfer to external drive, follow this FAQ for the instructions http://www.holdemmanager.net/faq/afm...aspx?faqid=101

[vgjfelix]

I looked at that faq but it wasn't clear how to actually move it to an external drive. It simply started creating a second database on the hard drive in my laptop.

[morny]

You just uninstall PostgreSQL after youve backed up the database (i also recommend exporting the hands in case theres any issues with restoring the backup http://www.holdemmanager.net/faq/afm...aspx?faqid=173)

Then install PostgreSQL and when it gets to the page where you choose the installation path choose the external drive rather than the c drive (this is step 5 in this FAQ http://www.holdemmanager.net/faq/?f=176). Then just follow the instuctions for restoring the database in the original file

[vgjfelix]

Ok, another brick wall to contend with.

Tried installing it on a portable hard drive and encountered the error that it's not NTFS formatted and I would need to do that. Wasn't prepared to do that so I tried to reinstall it back on my laptop but encountered the exact same problem. But hang on, I've had it installed on my laptop for a year previous and it's a FAT32 formatted drive.

What's going on there?

Thanks in advance.

[morny]

Its actually quite easy to do as you dont have to actually format anything so you wont lose any files. See this FAQ http://www.holdemmanager.net/faq/afm....aspx?faqid=71

The only thing that makes sense is that you accidentally didnt change either the main path or the database path and it still set to install on the external drive?

[vgjfelix]

"The only thing that makes sense is that you accidentally didnt change either the main path or the database path and it still set to install on the external drive?"

Just checked that now and nope it's definitely not allowing me to install postgresql on any drive! Like I said. My hard-drive on my macbook (windows side) has always been fat32 so I'm at a loss as to how I've been able to run holdem manager with no problems for over a year.

Is it possible that I had an older version of postgresql which worked on fat32 drives?

[morny]

Yeah i think 8.0 IIRC used to work for FAT. might have been that

[vgjfelix]

I've had a look for that version but it only appears to be for linux.

lol, this is such a mystery.

[morny]

It used to be available for windows, it appears they no longer support it so theyve taken away the download.