Re: Large pg_xlog - Mailing list pgsql-general

From Michael Paquier
Subject Re: Large pg_xlog
Date
Msg-id CAB7nPqRR7AHR3sw-6KeOeYRHePe_UHuiirNweZ96Kc_WMkbwrw@mail.gmail.com
Whole thread Raw
In response to Re: Large pg_xlog  (Francisco Reyes <lists@natserv.net>)
Responses Re: Large pg_xlog
List pgsql-general
On Thu, Sep 29, 2016 at 2:25 PM, Francisco Reyes <lists@natserv.net> wrote:
> There is no archive_status
>
>  ll 9.3/main/pg_xlog/ |grep arch
> postgres@s0pdb03:~$

Meh. There must be a folder named archive_status in pg_xlog. Or
something is broken with your installation. Don't you have in your log
files something like that?
LOG:  could not create archive status file
"pg_xlog/archive_status/000000010000000000000001.ready": No such file
or directory
That's what you would get if archive_status was for some reason
missing, and pg_xlog would just keep the WAL segments around until its
partition gets full.
--
Michael


pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Large pg_xlog
Next
From: Job
Date:
Subject: Out of memory in pg_bulkload