PDA

View Full Version : Postgresql large file



cimi
04-11-2011, 08:51 AM
Hello,

i have looked few pages and didnt really find anything regarding this matter, so i would like some advices.
I have problems with disc i have only 30GB and from this postgresql is 19GB so can someone help me how i can lower the size of postgresql?
I have found one link :
http://faq.holdemmanager.com/questions/85/Large+Log+Files

1. But what happens if i delete all of my postgresql?
2. What happens if i do this what is shown in link up. Will i lost all my previous hand? Will HM work normally? Will it save new hands while playing?
3. Any recommendations what i should do?

I already did full analyze and vacum.

THank you for your time and fast response.

Regards

Sarek
04-11-2011, 12:28 PM
If you delete all postgresql - you will lose your database. And HM will not work.
These log files you can delete without problems, but ONLY them.
And you can move database on another drive
http://faq.holdemmanager.com/questions/368/Move+Database+to+Another+Hard+Drive+or+Partition

cimi
04-12-2011, 02:36 AM
Hello,

I see ok so this means i can do this what is shown in link: http://faq.holdemmanager.com/questio...arge+Log+Files
and i wont lose anything if i do this? No hands nothing? And everything will work fine?

REgards

Sarek
04-12-2011, 06:07 AM
Yes, you don't lose any data.
And it works fine without these log files.

cimi
04-12-2011, 06:19 AM
I see ok thank you!
Am just one more question sorry, am but what are this files for then if you dont need them?

Sarek
04-12-2011, 11:28 AM
They are logs. To understand more - ask in special Postgre developers forums. :)

cimi
04-12-2011, 04:03 PM
Ok thank you for your time and help :)
you can close it i think.