Re: WAL recovery failure - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: WAL recovery failure
Date
Msg-id D960CB61B694CF459DCFB4B0128514C20874BE8A@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: WAL recovery failure  (Rick Dicaire <kritek@gmail.com>)
Responses Re: WAL recovery failure  (Rick Dicaire <kritek@gmail.com>)
List pgsql-admin
Rick Dicaire wrote:
>> /staging/9.1/main/pg_xlog is really archive directory?
restore_command
>> should be set to the command which copies the archived WAL files from
>> the archive area.
>
> Yes. This is the archive directory.

But according to what you wrote before you start the server
with -D /staging/9.1/main.
That means that /staging/9.1/main/pg_xlog contains the active
WAL files, right?

So the restore_command 'cp /staging/9.1/main/pg_xlog/%f "%p"'
would just try to cp the files onto themselves, right?

The WAL archive directory must be different from the
active WAL directory.  Check if that's your problem!

Yours,
Laurenz Albe


pgsql-admin by date:

Previous
From: Rick Dicaire
Date:
Subject: Re: WAL recovery failure
Next
From: Rick Dicaire
Date:
Subject: Re: WAL recovery failure