Postgres Pro
Downloads
Home   >   mailing lists

Re: WAL archive messages in streaming standby server's log - Mailing list pgsql-admin

From Matheus de Oliveira
Subject Re: WAL archive messages in streaming standby server's log
Date
Msg-id CAJghg4JA+1BwEciANc=jjanGLxTYPnBVix8pc790Szef2nCGTA@mail.gmail.com
Whole thread Raw
In response to WAL archive messages in streaming standby server's log  ("Scalia, John" <john.scalia@verizon.com>)
List pgsql-admin
Tree view

On Tue, May 6, 2014 at 2:41 PM, Scalia, John <john.scalia@verizon.com> wrote:
< 2014-05-06 13:41:17.710 EDT <@> % >DETAIL:  End of WAL reached on timeline 2 at 0/46000090.

Looks like you did a promotion or a complete restore and changed the timeline of your primary server.

If can add the following line on your recovery.conf file to make it follows the new timeline:

    recovery_target_timeline = latest

Best regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

pgsql-admin by date:

Previous
From: "Scalia, John"
Date:
Subject: WAL archive messages in streaming standby server's log
Next
From: "M. D."
Date:
Subject: table locking on creating FK