PostgreSQL 8.4 size is 108 GB

[Robert Fripp]

Hello,so my Postgres size is 108GB while the only DB that i have,is 4.6GB. What can be the problem and how could i solve it? Thank you!

[Robert Fripp]

I followed all of this steps: http://forums.holdemmanager.com/gene...too-large.html but the size of the Postgres is still 108GB and the DB 4.6 GB

[Patvs]

Does it state 108 GB in Windows: Control Panel--> Programs--> for PostgreSQL, or in
My Computer: C:/Program Files(x86)/PostgreSQL 108 GB is the size of the folder in the folder properties?

Is there 50 GB of files in your PostgreSQL/8.4/data/pg_log folder?
Are you using NoteCaddy?

[Robert Fripp]

Its says 108GB in Control Panel----Programs. In the folder it says 4.4 GB.
In that folder (there is no 8.4 folder) there is only one file that says this:

2012-08-23 17:29:47 ART LOG: el sistema de bases de datos fue apagado en 2012-08-23 17:29:20 ART
2012-08-23 17:29:47 ART FATAL: el sistema de base de datos está iniciándose
2012-08-23 17:29:47 ART LOG: el sistema de bases de datos está listo para aceptar conexiones
2012-08-23 17:29:47 ART LOG: lanzador de autovacuum iniciado
2012-08-23 17:30:55 ART WARNING: pgstat wait timeout
2012-08-23 17:32:04 ART WARNING: pgstat wait timeout
2012-08-23 17:32:28 ART LOG: se recibió petición de apagado rápido
2012-08-23 17:32:28 ART LOG: abortando transacciones activas
2012-08-23 17:32:28 ART LOG: apagando lanzador de autovacuum
2012-08-23 17:32:28 ART LOG: apagando
2012-08-23 17:32:28 ART LOG: el sistema de bases de datos está apagado

I let you know,that my computer is divided in 4 discs,and i have a bit of disorder in it,in case it has something to do.

I use NC,but only very simple stats vs Hero, and i followed the steps in this thread http://forums.holdemmanager.com/gene...too-large.html

Thank you!

[Patvs]

Its says 108GB in Control Panel----Programs

Windows is wrong.
It wrongly shows the database server activity in GB, not the actual size.

[koost]

Even though windows may be wrong. My drive SSD is now full with half of it being the 105 GB postgresql installation. I can no longer install applications on my C drive.

[Patvs]

In Windows--> Control Panel--> Programs--> it shows the wrong size.

...but if your database actually is taking up half your diskspace, you can do two things:
-1 in th Program Files(x86)/PostgreSQL/8.4/data/Pg_log folder delete all the files.
-2 Are you using NoteCaddy?
If YES, You can try resetting the Note Caddy notes. Do you have a lot of definitions?





If NO: is NoteCaddy maybe still turned on in HM2?
HM2: HUD Settings--> HUD Designer--> turn off show caddy notes, turn off start cady report on hud launch.
To then delete the NoteCaddy INDEX:

1) Please open PGAdminIII (Start - Postgres)

2) Enter your pw (default is postgrespass)

3) Open databases - expand DB name - expand schemas - expand public - expand Tables

4) Delete the note_caddy_scatter and note_caddy_data

PGAdmin info screen looks like this:
http://i291.photobucket.com/albums/l...dbrky/null.png

[udbrky]

Did you use a program like treesize free or windir stat to find what files are using how much space?