Re: Size of logfiles - Mailing list pgsql-admin

From Peter Elmers
Subject Re: Size of logfiles
Date
Msg-id EA0A5B63-C058-4E4E-9137-99F2E2F22B38@gmx.de
Whole thread Raw
In response to Re: Size of logfiles  (Peter Elmers <p.elmers@gmx.de>)
List 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.elmers@gmx.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


pgsql-admin by date:

Previous
From: Thomas Markus
Date:
Subject: Re: how to view all database,tables,users
Next
From: Ireneusz Pluta
Date:
Subject: Re: how to view all database,tables,users