Joby Joba <jobyjoba59(at)gmail(dot)com> wrote:
> Jan 28 11:35:01 abcd postgres[28359]: [81-1] LOG: archive command
> "cp "pg_xlog/000000010000000000000085"
> /u10/postgres/archive/"000000010000000000000085"" failed: return
> Jan 28 11:35:01 abcd postgres[28359]: [81-2] code 256
> The problem is that the requested file is not available anymore.
> How can I tell postgres to bypass this file ?
Get a new base backup and start the recovery over. Be sure to fix
whatever broken process caused the WAL file to be discarded while it
might still be needed.
-Kevin