Re: WAL archive messages in streaming standby server's log

From: Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com>
To: "Scalia, John" <john(dot)scalia(at)verizon(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: WAL archive messages in streaming standby server's log
Date: 2014-05-06 20:02:01
Message-ID: CAJghg4JA+1BwEciANc=jjanGLxTYPnBVix8pc790Szef2nCGTA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, May 6, 2014 at 2:41 PM, Scalia, John <john(dot)scalia(at)verizon(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message M. D. 2014-05-07 21:18:33 table locking on creating FK
Previous Message Scalia, John 2014-05-06 17:41:44 WAL archive messages in streaming standby server's log