From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
---|---|
To: | Carol Walter <walterc(at)indiana(dot)edu> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: What process clears the logs? |
Date: | 2008-09-30 21:58:36 |
Message-ID: | 48E2A10C.9060602@pinpointresearch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Carol Walter wrote:
> Ah-h-h, that's exactly my question. What part of Postgres "takes care
> of this itself." I'm asking because I had 86 pg_clog files dated back
> to mid-May. I got the impression from something Tom said that backups
> should prune this directory. Perhaps my "impression" was wrong. Most
> databases I've used in the past have gotten rid of the transaction
> logs, etc, when a backup is done. The restore process used that last
> backup and then applied the transaction logs to it. Once another
> backup was completed the old transaction logs were no longer needed.
> I'm trying to understand what happens "under the hood" so to speak.
> What checkpoint_settings value are you referring to?
Sorry. I had a brain/fingers disconnect. I meant the
"checkpoint_segments" setting. Anyway, answers to a number of your
questions regarding write-ahead logging may be found here:
http://www.postgresql.org/docs/8.3/interactive/wal-configuration.html
Cheers,
Steve
From | Date | Subject | |
---|---|---|---|
Next Message | Rafael Domiciano | 2008-10-01 00:54:09 | Re: [GENERAL] Functions |
Previous Message | Carol Walter | 2008-09-30 21:33:44 | Re: What process clears the logs? |