pg_basebackup restore & odd WAL - Mailing list pgsql-admin

From gleeco
Subject pg_basebackup restore & odd WAL
Date
Msg-id CADv14s_6fZT8XpjT=NYrRKm1-J2kTdGHSkremxMEVaV1SFV7cA@mail.gmail.com
Whole thread Raw
List pgsql-admin
hello - On 9.3, doing a restore of a sizeable db via pg_basebackup that was taken from a slave.

the new db fails to start up b/c its recovery is looking for a WAL sequence that does not exist (via the `backup_label` file?)

 0000000700002949000000AF.lzo   WANTED file
 000000070000293A000000FE.lzo   current - actual LIVE latest on master (24h later even!)

Since it was non-critical, i toy'd around with it a bit, and even `pg_resetxlog -f` did nothing.

how did my new restore get a sequence that looks far ahead (askew?) of the current master which the backup was derived from?  Any tl;dr solutions? 

stumped
-gleeco

(and thanks in advance!)

pgsql-admin by date:

Previous
From: Andrew Glen-Young
Date:
Subject: Systemtap + Postgresql production readiness
Next
From: Nagy László Zsolt
Date:
Subject: Could not shut down DB