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

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Jerry Sievers <gsievers19(at)comcast(dot)net>
Cc: Jeremy Finzel <finzelj(at)gmail(dot)com>, 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 03:54:42
Message-ID: 20190105035442.GI4849@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jan 04, 2019 at 08:41:35PM -0600, Jerry Sievers wrote:
> Take a look at the *.history file in pg_xlog or pg_wal.

These files are also archived. If you want to be able to see such
contents at SQL level, you would need some parsing logic like this one
for example which is a toy of mine (this comes mainly from
rewind_parseTimeLineHistory() if I recall correctly):
https://github.com/michaelpq/pg_plugins/tree/master/wal_utils
--
Michael

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mitar 2019-01-05 09:59:06 Dropping and creating a trigger
Previous Message Jerry Sievers 2019-01-05 02:41:35 Re: Get LSN at which a cluster was promoted on previous timeline