Want to stop Postgre from creating those large log files, here's how

[pfsrs4]

What about this folder C:\Program Files\PostgreSQL\8.3\data\base. This one is almost 12G . Can i delete this one?

Thanks

[morny]

DONT DELETE ANYTHING IN THERE - It will corrupt your database beyond repair

[pfsrs4]

understood, thanks Morny

[St3v3k4hn]

Is this still an issue with the latest postgres (8.4)? I looked and my log file was less than 1k...

[netsrak]

I'm not sure whether the different Postgresql versions are configured differently. But if your logs folder is nearly empty i assume its ok.

[microbob]

bumping this thread for awesomeness.

Had done some of the steps in the performance increase thread but wasn't getting any results really. I thought I had logging turned off already but I guess not. I had 1800 logs in there that I deleted. And right away my computer's performance with HUD on is hugely improved. What a difference. Hallelujah.

Encourage everyone to look into this on your computer if you have never done so. Screw all that bit about clearing the database or purging the HH's, etc (well, I guess you don't want to completely forget that stuff...but it didn't seem to make any difference for me)....this step is the real deal and seems to have really helped my HUD.

I had gotten to the point where all the little half-second delays were bugging me enough while 20+ tabling that I just stopped playing with the HUD completely for a little while.

[spoutnic]

hi kevin - The file you are trying to save...
It has something to do with log files ?
what instructions are you following ?

what is the file called ? (give the full name)
where is it ? (what's the name of the folder it's in ?)

I'm asking because some files\folders have similar names - easy to make a mistake

I think i have the same problem.

1.I change "on" to "off".
2.File, save and i get this:" impossible to create file C:\program\files\postgresSQL\8.3\data\postgresql.c omf, please check the name and access way are ok(translation from french, might not be the exact terms used in english)
3. I click ok
4.save as... options pops up
5.im in postgesql\8.3\data
6.i click save
7.its says :" postgesql.conf already exist, do you want to replace it?
8.I click yes
9. I get #2 message

What am i doing wrong?

i use vista

[netsrak]

Thats a permission problem under vista.

1. stop your postgresql service
2. open and edit the file and save it in a different folder like the desktop
3. rename the original file
4. move the changed file to the original folder.

[jenkulle]

would be good to mention that with 8.4 it's already turned off...


also you could add into your text to search for x line with ctrl+f ..a lot easier to look for ''logging_collector'' then scrolling down heheh

[Edmuntus]

What about this folder C:\Program Files\PostgreSQL\8.3\data\base. This one is almost 12G . Can i delete this one?

Thanks

How big is this going to get. I changed the postgresql.conf file long time ago and now see the file in the data\base map are getting huge.

Got 6 submaps in the data map

data\1
data\11510
data\11511
data\16438 -> 415MB
data\17624 -> 67,7 Giga Byte
data\pgsql_tmp

How can these be compressed or can they be deleted?

I also got a file in the Holdemmanager\Importing\Logs map called "Trace.bak" which is 4,5 GB and another one called "Trace.txt" of 1 GB.