Clustering possibly caused C drive to fill up

[Wada]

PostgreSQL 8.2 is installed on my C drive.

PT3 is installed on my D drive.

I had tried to recreate a lock up with new version of PT3 when I had already imported my exported PT2 hands by importing FTP hands from the Processed File HH folder.

It went through the importing process and at the end it automatically opened up a window and said it was "Clustering" the database. About 10 mins later it said that Drive C had only 40 megs left!! Huh??? Finally the clustering was done and I was trying to find out what happened. After searching through, I found that C:\Program Files\PostgreSQL\8.2\data\base\##### started having several folders with numbers on them. Looking through the latest folders, todays and yestersdays, sorted by Date Modified, I noticed these folders were over 1 GB!!!!

I deleted them so that I could get room back on my C drive and defragment it.

Sure sounds like a bug? Or was this user error?

[_dave_]

[quote="Wada"b53]I found that C:\Program Files\PostgreSQL\8.2\data\base\##### started having several folders with numbers on them. Looking through the latest folders, todays and yestersdays, sorted by Date Modified, I noticed these folders were over 1 GB!!!![/quoteb53]

That would be your database sir

[APerfect10]

How large is your hard drive? And how much free space did you have prior to installing PokerTracker 3?

Best regards,

Derek

[Wada]

The hard drive is 40 gigs. I had atleast 1 gig free for sure. I do not remember exactly how much free space I had.
When I deleted the two folders, it freed up to about 9 gigs.

Now when I open PT 3 (and PT2!!!!) I get this error window:

Unable to connect to the database
101-SQLSTATE = 08001
could not connect to server: Connection refused (oxoooo274D/10061)
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5433?

<OK Button>


What does this mean? I can not access my PT2 base as well. What can I do to fix this?

[_dave_]

unfortunately you seem to have deleted all your postgres databases - unless you have backups, I don't think there is a great deal of getting back from here.

You will have to re-import all your hands.

You probably need to run postgres "initdb" command too to re-initialize the database, or re-install postgres, if you actually did delete all the numbered files

[Josh]

It's a very bad idea to delete files when you aren't 100% sure of what they do. Harddrive space is cheap. You should go buy another disk if you can't clean off space on the one you have.

If you want to clear your drive of unnecessary files, try CCleaner: http://www.ccleaner.com/

[Wada]

I had restored them from the recycle bin. Even after restoring them - how do I go about this "initdb" command?

it seemed that it kept writing these files over and over, and there was like an endless loop of them. Some 8kb and some over 1,000,000 kb

How do I go about uninstalling - there is no uninstall option.

[_dave_]

If you've restored them all, cross fingers and reboot. Hopefully postgres hasn't destroyed itself in the meantime, and none are missing.

[Wada]

[quote="Josh"8j2]It's a very bad idea to delete files when you aren't 100% sure of what they do. Harddrive space is cheap. You should go buy another disk if you can't clean off space on the one you have.

If you want to clear your drive of unnecessary files, try CCleaner: http://www.ccleaner.com/[/quote8j2]

PT3 was in this clustering mode. it said to wait and it can take a while. I waited and did nothing.

Next windows in the lower right informs me that my drive C is full now. My drive had plenty of space before this clustering of PT3 came about!

And I used the CCleaner as well and all it did was remove 27megs. I had like over 3 gigs of space left, infact it was probably close to 9 gigs, given that those folders it created today totaled close to 9 gigs!

[_dave_]

how many hands did you import?

And yes, clustering uses up a good deal of space - it makes temporary copies of your entire database. You get the space back when all is done, but you need the temp. space.

Have you got lots of free space on D: you'd rather be using?