| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
| Cc: | Venkata B Nagothi <nag1010(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: FATAL: could not receive data from WAL stream |
| Date: | 2016-09-20 04:46:19 |
| Message-ID: | CAB7nPqQQcd9uqszrWbB2myN3q=2vPUwh9Rp-XMavTC8PvJLt4g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Sep 20, 2016 at 1:30 PM, Patrick B <patrickbakerbr(at)gmail(dot)com> wrote:
> 2016-09-20 15:14 GMT+12:00 Venkata B Nagothi <nag1010(at)gmail(dot)com>:
>> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick B | 2016-09-20 04:57:03 | Re: FATAL: could not receive data from WAL stream |
| Previous Message | Andreas Kretschmer | 2016-09-20 04:43:56 | Re: We have a requirement to downgrade from PostgreSQL 9.5.4 to 9.5.2 |