Re: Unable to recovery due missing wal_file - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Unable to recovery due missing wal_file
Date
Msg-id e72f01a4-4d3c-2992-747c-355deedd590d@aklaver.com
Whole thread Raw
In response to Re: Unable to recovery due missing wal_file  (Patrick B <patrickbakerbr@gmail.com>)
Responses Re: Unable to recovery due missing wal_file  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
On 07/03/2016 05:36 PM, Patrick B wrote:
> I don't have it now!
>
> But I didn't know that postgres would need that file! If I knew it, I'd
> have checked just after pg_basebackup started....

Not sure that would have mattered for the reasons below.

You might want to take a look at the below:

https://www.postgresql.org/docs/9.5/static/wal.html

In particular:

https://www.postgresql.org/docs/9.5/static/wal-intro.html

Short version WAL files are essential to restoring and on the
originating server are recycled, subject to the configuration parameters
explained here:

https://www.postgresql.org/docs/9.5/static/wal-configuration.html

So the wal archiving you have set up is not storing everything, it
removes older files over time?

--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Patrick B
Date:
Subject: Re: Unable to recovery due missing wal_file
Next
From: Craig Boyd
Date:
Subject: Re: psql connection option: statement_timeout