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

Re: Size of logfiles

From: Peter Elmers <p(dot)elmers(at)gmx(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Cc: Chris Browne <cbbrowne(at)acm(dot)org>
Subject: Re: Size of logfiles
Date: 2007-05-23 11:28:25
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

Just for other users who might have the same question:

With default settings, postgres writes 3 WAL files. Each of them has  
the size of 16 mb. They are located at the data directory within the  
subdirectory pg_xlog.



Am 22.05.2007 um 21:22 schrieb Peter Elmers:

> 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"))
>> "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
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at

In response to

pgsql-admin by date

Next:From: Ireneusz PlutaDate: 2007-05-23 12:03:58
Subject: Re: how to view all database,tables,users
Previous:From: Thomas MarkusDate: 2007-05-23 10:57:16
Subject: Re: how to view all database,tables,users

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