Search Postgresql Archives

Re: FATAL: could not receive data from WAL stream

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





2016-09-20 16:46 GMT+12:00 Michael Paquier <michael.paquier@xxxxxxxxx>:
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



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


I got some errors on the logs: systemd1: 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux