Re: WAL Archive Log

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Sam Nelson <samn(at)consistentstate(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: WAL Archive Log
Date: 2010-08-26 23:33:38
Message-ID: 1282865503-sup-4928@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Excerpts from Sam Nelson's message of jue ago 26 19:24:00 -0400 2010:
> Is there a way to get postgres to write a line to the log file when it
> creates a WAL file? We wrote a script that tries to grab the times between
> WAL file creation and ingestion without stopping to make absolutely sure
> that postgres actually logs the WAL file creation, and so we're kinda stuck
> staring at our screens and blinking.

Not currently.

WAL files are created well in advance of them being used, so perhaps
there is no point, depending on what you want to do with the
information.

File recycling (which is the usual mechanism for them being created) is
logged, sort of: it happens during checkpoint.

--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Christensen 2010-08-27 06:30:27 Is your data okay?
Previous Message Sam Nelson 2010-08-26 23:24:00 WAL Archive Log