Skip site navigation (1) Skip section navigation (2)

Re: Size of logfiles

From: Peter Elmers <p(dot)elmers(at)gmx(dot)de>
To: Chris Browne <cbbrowne(at)acm(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Size of logfiles
Date: 2007-05-22 19:22:58
Message-ID: 83FDC4F6-66A4-47D7-B88D-BBF95647305B@gmx.de (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Chris,

Thanks for your fast reply. Indeed i ment the normal logfiles. But  
you point me to another question:

I am just reading the manual regarding WAL, but until now, i found no  
hint about the default setting for the redo-logs(WAL).
Can you give me a hint?

Thanks,


Peter


Am 21.05.2007 um 16:44 schrieb Chris Browne:

> p(dot)elmers(at)gmx(dot)de (Peter Elmers) writes:
>> I have searched the web and am sorry to say that i found nothing
>> about the default behavior of the log files of postgres.
>>
>> Can anyone tell me when postgres will delete the logfiles or what
>> postgres automatically do with them?
>
> Can you be a bit more precise about that?
>
> There are the WAL log files; I expect you're not talking about that.
>
> I expect you're talking about the log files containing error messages,
> warnings, and such.
>
> PostgreSQL will not, itself, purge out such files; consider that you
> can configure it to distribute log information via syslog, which would
> push the logs into a mostly OS-managed area.
>
> You'll presumably want to figure out what YOU want your policy to be,
> and find suitable tools (lots available) to implement that policy...
> -- 
> (reverse (concatenate 'string "ofni.secnanifxunil" "@" "enworbbc"))
> http://linuxfinances.info/info/linuxxian.html
> "We should start referring to processes which run in the background by
> their correct technical name:... paenguins."  -- Kevin M Bealer
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings


In response to

Responses

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2007-05-22 19:30:10
Subject: Re: What happens on a commit?
Previous:From: Peter ElmersDate: 2007-05-22 19:15:40
Subject: Re: Size of logfiles

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group