On Tue, Sep 20, 2016 at 1:30 PM, Patrick B <patrickbakerbr@xxxxxxxxx> wrote: > 2016-09-20 15:14 GMT+12:00 Venkata B Nagothi <nag1010@xxxxxxxxx>: >> Do you mean to say that the WAL file "000000020000179A000000F8" is >> available @ "/var/lib/pgsql/9.2/archive" location ? > > Yes! Timeline 2 has visibly reached its end at segment 000000020000179A000000F8 and it cannot find in the archive the history file to see from which timeline it needs to fetch afterwards. As the timeline file cannot be found, it then attempts to fetch the segment that it thinks is complete from the master itself. Didn't you trigger a promotion which would make the master reach the timeline 3? And are you sure that 00000003.history is not in the archives? -- Michael -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
