Re: Get LSN at which a cluster was promoted on previous timeline

From: Jerry Sievers <gsievers19(at)comcast(dot)net>
To: Jeremy Finzel <finzelj(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Get LSN at which a cluster was promoted on previous timeline
Date: 2019-01-05 02:41:35
Message-ID: 87zhsfzuzk.fsf@jsievers.enova.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeremy Finzel <finzelj(at)gmail(dot)com> writes:

> I am having a hard time finding out how I can easily determine at
> which LSN a streamer was promoted after promotion.  A related
> question is that if I pause wal replay, I am able to see the last
> replayed LSN but I can't simply immediately promote.

Take a look at the *.history file in pg_xlog or pg_wal.

> I want to know the state of the streamer post-promotion with respect
> to the master by getting the LSN at which it was promoted.
>
> Thanks,
> Jeremy
>
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2019-01-05 03:54:42 Re: Get LSN at which a cluster was promoted on previous timeline
Previous Message Jeremy Finzel 2019-01-05 01:36:53 Get LSN at which a cluster was promoted on previous timeline