Re: FATAL: could not receive data from WAL stream

2016-09-20 16:46 GMT+12:00 Michael Paquier <michael(dot)paquier(at)gmail(dot)com>:

> 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
>

The server went down and when it came back online I got that errors..

I got some errors on the logs: systemd1
<https://jirageoop.atlassian.net/wiki/display/RI/1>: Removed slice User
Slice of postgres.

I belive something happened with Postgres user and when the server came
back online it started postgres in a new path... that excluded
recovery.conf and the server might have been promoted as master

This means I'll have to re-build the DB right?

Patrick