On 8/26/16 4:17 PM, Andres Freund wrote:
> On 2016-08-26 18:46:42 +0300, Yury Zhuravlev wrote:
>> Thanks all.
>> Now understand LSN strongly connected with WAL.
>> However how difficult put last system LSN instead 0?
>> It's not so important but will allow make use LSN more consistent.
>
> Maybe explain why you're interested in page lsns, that'd perhaps allow
> us to give more meaningful feedback.
Yeah, especially since you mentioned this being for backups. I suspect
you *want* those WAL records marked with 0, because that tells you that
you can't rely on WAL when you back that data up.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-9461