Re: WAL Archiving Stopped - Mailing list pgsql-general

From Norberto Delle
Subject Re: WAL Archiving Stopped
Date
Msg-id 4D2326BE.3040307@gmail.com
Whole thread Raw
In response to Re: WAL Archiving Stopped  (Filip Rembiałkowski <plk.zuber@gmail.com>)
Responses Re: WAL Archiving Stopped  (Filip Rembiałkowski <plk.zuber@gmail.com>)
List pgsql-general
Em 3/1/2011 18:39, Filip Rembiałkowski escreveu:
> archiver process will retry later; it never stops trying, sleep time
> is just longer.
>
> 2011/1/3, Norberto Delle<betodelle@gmail.com>:
>> Hi all
>>
>> I have a PostgreSQL 9.0.1 instance, with WAL Archiving.
>> Today, after some failed tries to archive a WAL file, it stopped trying
>> to archive the files,
>> but the number of logfiles in the pg_xlog directory keep growing.
>> Any ideas of what is going on?
>>
>> Norberto
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
Hi Filip

It was taking too long to retry,  a matter of hours.
I had to restart the service to it start trying to archive the wal files.

Norberto

pgsql-general by date:

Previous
From: Shoma S Achar
Date:
Subject: Updated Latch Patch
Next
From: "Kurt Westerfeld"
Date:
Subject: Re: Date Parameter To Query Confusing Optimizer