From: Rafael Domiciano <rafael.domiciano@gmail.com>
To: Steve Crawford <scrawford@pinpointresearch.com>
Cc: Carol Walter <walterc@indiana.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: What process clears the logs?
Date: Tue, 30 Sep 2008 23:15:37 -0200
Message-ID: <3a0028490809301815x2d019ff9l3a08d81840156b75@mail.gmail.com> (raw)
In-Reply-To: <48E2A10C.9060602@pinpointresearch.com>
References: <64D96E8A-8E58-458C-B299-8998112F88FA@indiana.edu>
<48E27D72.9040409@pinpointresearch.com>
<ED139E0C-2CA8-4761-81D5-CFE6FD1A7E7F@indiana.edu>
<48E2A10C.9060602@pinpointresearch.com>
Hello Carol,
Maybe I'm thinking wrong, but I have a problem like yours; and I realize
that the vacuum Freeze that does that work.
I have read that somewhere in the net, that I don't remember now.
To prevent that I created a proccess that run every night, that vacuums the
database, and started the vacuum daemon.
All machines I had problems are Slony-slaves.
Best Regards,
Rafael Domiciano
Postgres DBA
2008/9/30 Steve Crawford <scrawford@pinpointresearch.com>
> 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
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rafael.domiciano@gmail.com, scrawford@pinpointresearch.com, walterc@indiana.edu
Subject: Re: What process clears the logs?
In-Reply-To: <3a0028490809301815x2d019ff9l3a08d81840156b75@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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