pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSize of logfiles
6+ messages / 3 participants
[nested] [flat]
* Size of logfiles
@ 2007-05-21 13:38 Peter Elmers <p.elmers@gmx.de>
2007-05-21 14:42 ` Re: Size of logfiles Peter Eisentraut <peter_e@gmx.net>
2007-05-21 14:44 ` Re: Size of logfiles Chris Browne <cbbrowne@acm.org>
0 siblings, 2 replies; 6+ messages in thread
From: Peter Elmers @ 2007-05-21 13:38 UTC (permalink / raw)
To: pgsql-admin
Hi!
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?
Best regards,
Peter
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Size of logfiles
2007-05-21 13:38 Size of logfiles Peter Elmers <p.elmers@gmx.de>
@ 2007-05-21 14:42 ` Peter Eisentraut <peter_e@gmx.net>
2007-05-22 19:15 ` Re: Size of logfiles Peter Elmers <p.elmers@gmx.de>
1 sibling, 1 reply; 6+ messages in thread
From: Peter Eisentraut @ 2007-05-21 14:42 UTC (permalink / raw)
To: pgsql-admin; +Cc: Peter Elmers <p.elmers@gmx.de>
Am Montag, 21. Mai 2007 15:38 schrieb Peter Elmers:
> I have searched the web and am sorry to say that i found nothing
> about the default behavior of the log files of postgres.
That's easy: By default, postgres doesn't write a log file.
There are about half a dozen ways to set this up, though.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Size of logfiles
2007-05-21 13:38 Size of logfiles Peter Elmers <p.elmers@gmx.de>
2007-05-21 14:42 ` Re: Size of logfiles Peter Eisentraut <peter_e@gmx.net>
@ 2007-05-22 19:15 ` Peter Elmers <p.elmers@gmx.de>
0 siblings, 0 replies; 6+ messages in thread
From: Peter Elmers @ 2007-05-22 19:15 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin
Hi Peter,
Thank you for your fast reply. Yes, indeed i ment the normal error-
logfiles.
But if i start postgres with "-l" what duration does the logfiles have?
Thanks,
Peter
Am 21.05.2007 um 16:42 schrieb Peter Eisentraut:
> Am Montag, 21. Mai 2007 15:38 schrieb Peter Elmers:
>> I have searched the web and am sorry to say that i found nothing
>> about the default behavior of the log files of postgres.
>
> That's easy: By default, postgres doesn't write a log file.
>
> There are about half a dozen ways to set this up, though.
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Size of logfiles
2007-05-21 13:38 Size of logfiles Peter Elmers <p.elmers@gmx.de>
@ 2007-05-21 14:44 ` Chris Browne <cbbrowne@acm.org>
2007-05-22 19:22 ` Re: Size of logfiles Peter Elmers <p.elmers@gmx.de>
1 sibling, 1 reply; 6+ messages in thread
From: Chris Browne @ 2007-05-21 14:44 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Size of logfiles
2007-05-21 13:38 Size of logfiles Peter Elmers <p.elmers@gmx.de>
2007-05-21 14:44 ` Re: Size of logfiles Chris Browne <cbbrowne@acm.org>
@ 2007-05-22 19:22 ` Peter Elmers <p.elmers@gmx.de>
2007-05-23 11:28 ` Re: Size of logfiles Peter Elmers <p.elmers@gmx.de>
0 siblings, 1 reply; 6+ messages in thread
From: Peter Elmers @ 2007-05-22 19:22 UTC (permalink / raw)
To: Chris Browne <cbbrowne@acm.org>; +Cc: 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.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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Size of logfiles
2007-05-21 13:38 Size of logfiles Peter Elmers <p.elmers@gmx.de>
2007-05-21 14:44 ` Re: Size of logfiles Chris Browne <cbbrowne@acm.org>
2007-05-22 19:22 ` Re: Size of logfiles Peter Elmers <p.elmers@gmx.de>
@ 2007-05-23 11:28 ` Peter Elmers <p.elmers@gmx.de>
0 siblings, 0 replies; 6+ messages in thread
From: Peter Elmers @ 2007-05-23 11:28 UTC (permalink / raw)
To: pgsql-admin; +Cc: Chris Browne <cbbrowne@acm.org>
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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2007-05-23 11:28 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-05-21 13:38 Size of logfiles Peter Elmers <p.elmers@gmx.de>
2007-05-21 14:42 ` Peter Eisentraut <peter_e@gmx.net>
2007-05-22 19:15 ` Peter Elmers <p.elmers@gmx.de>
2007-05-21 14:44 ` Chris Browne <cbbrowne@acm.org>
2007-05-22 19:22 ` Peter Elmers <p.elmers@gmx.de>
2007-05-23 11:28 ` Peter Elmers <p.elmers@gmx.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox