Search Postgresql Archives

Re: During promotion, new master tries to archive same segment twice

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

 



Adrian Klaver wrote:
On 08/16/2018 01:48 AM, Phil Endecott wrote:
Adrian Klaver wrote:
On 08/15/2018 01:25 PM, Phil Endecott wrote:
Dear Experts,


The above is not clear to me. My best guess:


It's not part of the error for the archive command; it's just the
next thing in the log file.  Y is (1) trying write WAL segment
E8 to the Y-to-Z archive and failing because it is already there and
(2) trying to read WAL segment E9 from the X-to-Y archive and failing
because it doesn't exist (and never will).  (1) is the problem, (2) is
expected.

Hmm, still not sure why they are both showing up in the same LOG: entry as the entry was for the failure of the archive_command.

It's not.  It's just the next thing in the log file.  It seems that
stderr output from scp appears raw in the log file.

What is archive_mode set to on Y?

archive_mode = always


Regards, Phil.








[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