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

[MacUser]

TY for this info. Just setting up a new laptop (w Windows 7) and it won't let me save the changes in notepad, saves I don't have permission to save in this location and to contact administrator. Any ideas anyone?

EDIT: Okay, I found elsewhere that you should just save the file elsewhere and copy it where it needs to be. So I did that, and now in the postgres 'data' folder I two postgresql.con files. Under 'type', the original says 'conF file' and the revised one says 'text' file. If I just delete the original will postgres use the 'text' file?

[netsrak]

No that will not work.
You need to delete the original file (or rename it as backup).
Then you need to rename your txt file to the original filename.

Notepad unfortunately automatically adds a .txt extension when editing a file.

After the renaming you need to restart your postgresql service (or reboot your computer).

[runhot]

im trying to turn the logging off, and i'm getting an error while trying to save in notepad that says "Access is denied".

This is when im trying to save the edited .conf file.

i have also tried making a copy of the file, naming it, changing the extension to txt, then make the edit, then try to save-- and its still saying 'access denied'

ive never seen this before.

[netsrak]

stop postgresql service,
rename the original file,
rename the copy to the original file
and restart postgresql.

You need Administrator rights to do this.

[111AYKY111]

does this work for 8.4 as well?

[netsrak]

It should work, check the comments in the conf files

[Polar_Bears]

I don't understand....why are we doing this?? Log files aren't just created for no reason....what exactly am I deleting here? What could I possibly lose down the road or cause by deleting these log files and changing the switch to off in the postgresql.conf file?

My postgresql.conf file is 18 gigs big.

[_Loki_]

the log files are useful maybe for troubleshooting purposes should you have a problem with postgreSQL etc, but if you get troubles old logs aren't going to help

FAQ - Hold'em Manager Poker Tracking Software :: Large Log Files

If you don't like the idea just delete the logs but keep logging active

[Kevin86]

When I try to save the changes I made, it says' make sure the path is correct...

So for some reason I can't seem to save it

pls assist.

[_Loki_]

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