PDA

View Full Version : POSTSQL "base" folder = 26 gigs?



4entourage
08-11-2009, 05:21 PM
I love all the help Im getting and I finally deleted and disabled logging of SQL which on one PC cleared up about 18 of the 21 gigs that was used in the SQL folder.

Now that I put Windows 7 on my pc --- and had backed up and restored through postSQL --- I have a new growing problem.

My Program Files\PostgreSQL\8.3\Data has a folder in it called "base" and it has 6 folders in it :

1 - 4.15 MB
11510 - 4.14 MB
11511 - 4.23 MB
16403 - 2.75 GB's
17211 - 18.9 GB's
pgsql_tmp - Empty

Why is there those 2 huge folders and is there anything I can do to get that space back? After format of an 80 gig drive (around 72 usable) I was at around 40ish--- now after coming home after the restore was complete Im at around 10 gigs left only

netsrak
08-12-2009, 03:05 AM
This are not folders it are files. They are the database. Don't touch any of this files or you will loose all your data.

The database needs round about 10 GB per 1 Million hands.

To save or regain space you can do regular maintenance.
- purge hands
- vacuum / analyze full
- defrag harddisk with not running postgresql services

but as i said a database consuming lots of GBs of space is not unusual.

Diesel7
05-02-2012, 02:48 PM
I've lost all my hands, but i have this folder still. Is there any way i can extract actual hands from it into my new DB?

Patvs
05-03-2012, 09:32 PM
Let's suppose you were using PostgreSQL 8.4
You still have the C:/Program Files/PostgreSQL/8.4/data folder (which includes the /base subfolder)

If you reinstall PostgreSQL with the installer from postgresql.org it will give you the option to choose the location of the /data folder.
If you select your old existing /data folder, HoldemManager will be able to connect to the old database, and you can export your hands.

It's not possible to extract the hands straight from the files in the /base folder.

Diesel7
05-04-2012, 01:11 AM
Awesome! Thanks.