Re: Get LSN at which a cluster was promoted on previous timeline - Mailing list pgsql-general

From Michael Paquier
Subject Re: Get LSN at which a cluster was promoted on previous timeline
Date
Msg-id 20190105035442.GI4849@paquier.xyz
Whole thread Raw
In response to Re: Get LSN at which a cluster was promoted on previous timeline  (Jerry Sievers <gsievers19@comcast.net>)
List 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

Attachment

pgsql-general by date:

Previous
From: Jerry Sievers
Date:
Subject: Re: Get LSN at which a cluster was promoted on previous timeline
Next
From: Mitar
Date:
Subject: Dropping and creating a trigger