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: EA0A5B63-C058-4E4E-9137-99F2E2F22B38@gmx.de (view raw or flat)
Thread:
Lists: pgsql-admin
Hi!

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.

Cheers,


Peter

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"))
>> 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
>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>                http://www.postgresql.org/about/donate


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-2014 The PostgreSQL Global Development Group