Hi,

The postgresql map in program files is larger than 30gb
That's a little bit too much offcourse and I have a feeling it might have something to do with PT's database :P lol

so I was planning on deleting my database but maybe make a backup just in case I want to review some things later on
I tried using the export button in database management but the software freezes
Is there a way to manually copy/paste some files to my external HD?

If that's too much of a hassle, I don't mind deleting it as a whole, can I use PT to do it? (does it delete these postgresql files?)
If not, what files do I manually delete?
or maybe uninstall/reinstall postgresql?

I'm making a new and making sure it won't become that big.
my old database has never been clustered/analyzed/vacuumd so maybe that's a problem too? (didnt know it was necessary and if I try it now it'll probably take 3 days or something like that, with my new one I'm doing it every day from now on offcourse )

any other tips I should know?
I import like 60-70k hands every day (HH service)

I was thinking on making a database for every month of the year or maybe every 2monts/quarterly

thanks in advance
Timothy

Follow this post to backup your PostgreSQL database. If you click Database --> Database Management, click on your database and click Delete it will delete the data from the database. You'll want to run housekeeping after as if you don't run vacuum the data won't be reclaimed from the PostgreSQL map.

And a 30G database isn't all that odd; that's roughly 3M hands, give or take a bit. The PT3 database stores a lot of data in each database.

Making monthly/bimonthly or quarterly databases and then deleting ones significantly out of date is what I know a few people do.

thanks!
well I tried to backup with pg admin but it kept crashing so I had to restart again ("not responding")
now it just finished and the backup file is only 1.59gb?
this can't be right imo, what am I doing wrong?
I used the backup and not the tar option, I made the backup to my external HD

edit: another question, I also have PT2 and want to delete the program+its database, fastest/easiest way to do this?