Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lP7jz-0004w2-ST for pgsql-docs@arkaria.postgresql.org; Wed, 24 Mar 2021 17:56:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lP7jy-0000mX-Pd for pgsql-docs@arkaria.postgresql.org; Wed, 24 Mar 2021 17:56:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lP2yZ-00084v-W3 for pgsql-docs@lists.postgresql.org; Wed, 24 Mar 2021 12:51:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lP2yW-0005Qq-Nr for pgsql-docs@lists.postgresql.org; Wed, 24 Mar 2021 12:51:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=LpsP5dKHGso+5mgeR5Mc5l+Y4XIz0flOCM9TcpwcPtQ=; b=cRcnFwqqFGAsEPHpgjT8PQnunl ufJl+i1NEQGpANswvSfYOMoCiy0q4c5FOeETNWXHNhBImOTMTH6AU8KTXI1TvnZ8wpmOvVor2ptcy fmAfz0X2CU7p7+bhorIn3YmNaeXyS9KGN6P1XE7Vj1zp/3+4W9fO1rudXRM4Tdcc9vh8WVKLwxJqC XG1a6jJW0eqQUYMuONXF7ir+tZN6iu1Eb5iXpSiXAIYWhPEb4jzAEpzEz4Hlhz1ntw3pH+yp1m9C8 1+RWG5AifT3ol4RuBNzW+5P7De51atpbHS/mB4Pz5+0g52Frunq+4LeP5B9CVqYbiLfuKQvSeajvo TDVAX8vg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lP2yW-0005gE-6R for pgsql-docs@lists.postgresql.org; Wed, 24 Mar 2021 12:51:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lP2yU-0004fB-7M for pgsql-docs@lists.postgresql.org; Wed, 24 Mar 2021 12:51:02 +0000 Content-Type: multipart/mixed; boundary="===============7633640925931430725==" MIME-Version: 1.0 Subject: Logical replication restart position (restart_lsn) To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: chris+postgresql@qwirx.com Reply-To: chris+postgresql@qwirx.com, pgsql-docs@lists.postgresql.org Date: Wed, 24 Mar 2021 12:50:13 +0000 Message-ID: <161659021377.695.8314130669179661646@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7633640925931430725== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMC93YXJt LXN0YW5kYnkuaHRtbApEZXNjcmlwdGlvbjoKCkhpLCBJIHdhcyBzdHJ1Z2dsaW5nIHRvIHVuZGVy c3RhbmQgd2h5IG15IGxvZ2ljYWwgcmVwbGljYXRpb24gY2xpZW50cyAodXNpbmcKdGhlIHdhbDJq c29uIHBsdWdpbikgYXJlIG5vdCBhZHZhbmNpbmcgdGhlIHJlc3RhcnRfbHNuIGFzIG11Y2ggYXMg SQpleHBlY3RlZC4gRS5nLiBJIHJlZ3VsYXJseSBzZWUgcmVzdGFydF9sc24gYmVjb21pbmcgMUdC IG9yIG1vcmUgYmVoaW5kCmNvbmZpcm1lZF9mbHVzaF9sc24sIGJ1dCBpdCBhbHdheXMgY2F0Y2hl cyB1cCBldmVudHVhbGx5ICh3aXRoaW4gYW4gaG91cikuDQoNClRoZSBkb2N1bWVudGF0aW9uIGRv ZXNuJ3Qgc2VlbSB0byBleHBsYWluIHdoeSB0aGlzIGNhbiBoYXBwZW4sIG9ubHkgdGhhdAoicmVz dGFydF9sc24gW2lzXSBUaGUgYWRkcmVzcyAoTFNOKSBvZiBvbGRlc3QgV0FMIHdoaWNoIHN0aWxs IG1pZ2h0IGJlCnJlcXVpcmVkIGJ5IHRoZSBjb25zdW1lciBvZiB0aGlzIHNsb3QgYW5kIHRodXMg d29uJ3QgYmUgYXV0b21hdGljYWxseQpyZW1vdmVkIGR1cmluZyBjaGVja3BvaW50cy4uLiIKPGh0 dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvMTMvdmlldy1wZy1yZXBsaWNhdGlvbi1zbG90 cy5odG1sPi4gDQoNCldlIGFyZSBhZHZpc2VkIHRvIG1vbml0b3IgbG9naWNhbCByZXBsaWNhdGlv biBpbiBhIHNpbWlsYXIgd2F5IHRvIHBoeXNpY2FsCnJlcGxpY2F0aW9uIChlLmcuIHVzaW5nIHBn X3JlcGxpY2F0aW9uX3Nsb3RzKQo8aHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMy9s b2dpY2FsLXJlcGxpY2F0aW9uLW1vbml0b3JpbmcuaHRtbD4sCnByZXN1bWFibHkgdG8gYXZvaWQg aW5maW5pdGUgV0FMIGJ1aWxkdXAgYW5kIGV4aGF1c3RpbmcgZGlzayBzcGFjZSBvbiB0aGUKbWFz dGVyLiAoQW5kIHNpbWlsYXJseSwgIkFuIGltcG9ydGFudCBoZWFsdGggaW5kaWNhdG9yIG9mIHN0 cmVhbWluZwpyZXBsaWNhdGlvbiBpcyB0aGUgYW1vdW50IG9mIFdBTCByZWNvcmRzIGdlbmVyYXRl ZCBpbiB0aGUgcHJpbWFyeSwgYnV0IG5vdAp5ZXQgYXBwbGllZCBpbiB0aGUgc3RhbmRieS4iKSBI b3dldmVyLCBubyBhZHZpY2UgYWJvdXQgbW9uaXRvcmluZwpyZXN0YXJ0X2xzbiBpcyBnaXZlbiwg b3IgcmVhc29uYWJsZSBsZXZlbHMgb2YgcmVzdGFydCBsYWcuDQoNCkkgZm91bmQgYSBkaXNjdXNz aW9uIG9uIHBnc3FsLWhhY2tlcnMKPGh0dHBzOi8vd3d3LnBvc3RncmVzcWwtYXJjaGl2ZS5vcmcv TW92ZW1lbnQtb2YtcmVzdGFydC1sc24tcG9zaXRpb24tbW92ZW1lbnQtb2YtbG9naWNhbC1yZXBs aWNhdGlvbi1zbG90cy1pcy12ZXJ5LXNsb3ctdGQ2MTY3MjE5Lmh0bWw+CndoZXJlIHBhcnRpY2lw YW50cyBzYWlkOg0KDQoiSW4gb3VyIG9ic2VydmF0aW9uIHZpYSBQU1FMIHRoZSBhZHZhbmNlIGNv bW1hbmQgYXMgd2VsbCBkbyBub3QgbW92ZSB0aGUKcmVzdGFydF9sc24gaW1tZWRpYXRlbHkuIg0K DQoiVGhlIHJlc3RhcnRfbHNuIGlzIGxzbiByZXF1aXJlZCBieSB0aGUgb2xkZXN0IHR4bi4iIA0K DQoiZXZlbiB0aG91Z2ggd2UgdXBkYXRlIGNvbmZpcm1lZF9mbHVzaF9sc24gZXZlcnkgdGltZSB3 aXRoIHRoZSBuZXcgdmFsdWUgYnV0CnJlc3RhcnRfbHNuIGlzIHVwZGF0ZWQgb25seSB3aGVuIGNh bmRpZGF0ZV9yZXN0YXJ0X3ZhbGlkIGhhcyBhIHZhbGlkIHZhbHVlCmVhY2ggdGltZSBhZnRlciBh IGNhbGwgdG8gTG9naWNhbENvbmZpcm1SZWNlaXZlZExvY2F0aW9uLiBXZQ0KdXBkYXRlIGNhbmRp ZGF0ZV9yZXN0YXJ0X3ZhbGlkIGluIExvZ2ljYWxJbmNyZWFzZVJlc3RhcnREZWNvZGluZ0ZvclNs b3QKd2hpY2ggaXMgY2FsbGVkIG9ubHkgZHVyaW5nIGRlY29kaW5nIG9mIFhMT0dfUlVOTklOR19Y QUNUUyByZWNvcmQuIg0KDQpUaGUgY29tbWVudCAiVGhlIHJlc3RhcnRfbHNuIGlzIGxzbiByZXF1 aXJlZCBieSB0aGUgb2xkZXN0IHR4biIgZG9lc24ndCBzZWVtCnRvIGJlIGV4YWN0bHkgdHJ1ZSwg YXMgSSBoYXZlIHNlZW4gdGhlIHJlc3RhcnRfbHNuIHBvaW50aW5nIHRvIHNuYXBzaG90cwp3aXRo IHJ1bm5pbmcgdHJhbnNhY3Rpb25zLCBzdWNoIGFzIHRoaXMgb25lOg0KDQpybWdyOiBTdGFuZGJ5 ICAgICBsZW4gKHJlYy90b3QpOiAgICAgNTQvICAgIDU0LCB0eDogICAgICAgICAgMCwgbHNuOgpF M0EvOTEyQjgwMzAsIHByZXYgRTNBLzkxMkI3RjUwLCBkZXNjOiBSVU5OSU5HX1hBQ1RTIG5leHRY aWQgNDg3MDc3NjYzCmxhdGVzdENvbXBsZXRlZFhpZCA0ODcNCjA3NzY2MSBvbGRlc3RSdW5uaW5n WGlkIDQ4NzA3NzY2MjsgMSB4YWN0czogNDg3MDc3NjYyDQoNCkhvd2V2ZXIsIEkgYWxzbyBmb3Vu ZCB0aGF0ICJbYSBzbmFwc2hvdF0gaGFzIHJvb20gZm9yIGF0IG1vc3QgNjQgbm9uLWFib3J0ZWQK c3VidHJhbnNhY3Rpb25zIHBlciBzZXNzaW9uLiBJZiB0aGVyZSBhcmUgbW9yZSB0aGFuIDY0IHN1 Y2ggc3VidHJhbnNhY3Rpb25zLAp0aGUgc25hcHNob3QgaXMgbWFya2VkIGFzIHN1Ym92ZXJmbG93 ZWQuIEEgc3Vib3ZlcmZsb3dlZCBzbmFwc2hvdCBkb2VzIG5vdApjb250YWluIGFsbCBkYXRhIHJl cXVpcmVkIHRvIGRldGVybWluZSB2aXNpYmlsaXR5LCBzbyBQb3N0Z3JlU1FMIHdpbGwKb2NjYXNp b25hbGx5IGhhdmUgdG8gcmVzb3J0IHRvIHBnX3N1YnRyYW5zLiIKPGh0dHBzOi8vd3d3LmN5YmVy dGVjLXBvc3RncmVzcWwuY29tL2VuL3N1YnRyYW5zYWN0aW9ucy1hbmQtcGVyZm9ybWFuY2UtaW4t cG9zdGdyZXNxbC8+CihXaGljaCBpcyBub3QgcG9zc2libGUgYWZ0ZXIgYSBzZXJ2ZXIgY3Jhc2gs IHNpbmNlIHBnX3N1YnRyYW5zIGlzIGRpc2NhcmRlZCwKaGVuY2UgYSBzdWJvdmVyZmxvd2VkIHRy YW5zYWN0aW9uIGNhbm5vdCBiZSBhIHZhbGlkIHJlc3RhcnQgcG9pbnQ/KQ0KDQpUaGVyZWZvcmUs IEkgc3VybWlzZSB0aGF0IHJlc3RhcnRfbHNuIG11c3QgcG9pbnQgdG8gYSBSVU5OSU5HX1hBQ1RT IFdBTApyZWNvcmQgKGEgc25hcHNob3Q/KSB3aGljaCBpcyBub3Qgc3Vib3ZlcmZsb3dlZCAoZG9l cyBub3QgaGF2ZSB0aGUgInN1YnhpZApvdmYiIGZsYWcpLCBhbmQgdGh1cyB0aGUgcmVzdGFydF9s c24gd2lsbCBwb2ludCB0byB0aGUgbW9zdCByZWNlbnQgc3VjaApyZWNvcmQgYmVmb3JlIHRoZSBj bGllbnQncyBjb25maXJtZWRfZmx1c2hfbHNuLiBGcm9tIG9ic2VydmF0aW9uIHRoYXQgYWxzbwph cHBlYXJzIHRvIGJlIHRoZSBjYXNlLg0KDQpJZiB0aGlzIGlzIGNvcnJlY3QsIEkgdGhpbmsgaXQg d291bGQgYmUgZ3JlYXQgaWYgaXQgd2FzIGluIHRoZSBvZmZpY2lhbApkb2N1bWVudGF0aW9uLiBQ ZXJoYXBzIHNvbWV0aGluZyBsaWtlIHRoaXMgb24gdGhlIHBnX3JlcGxpY2F0aW9uX3Nsb3RzIHBh Z2U/CjxodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzLzEzL3ZpZXctcGctcmVwbGljYXRp b24tc2xvdHMuaHRtbD4NCg0KIlRoZSBhZGRyZXNzIChMU04pIG9mIG9sZGVzdCBXQUwgd2hpY2gg c3RpbGwgbWlnaHQgYmUgcmVxdWlyZWQgYnkgdGhlCmNvbnN1bWVyIG9mIHRoaXMgc2xvdCBhbmQg dGh1cyB3b24ndCBiZSBhdXRvbWF0aWNhbGx5IHJlbW92ZWQgZHVyaW5nCmNoZWNrcG9pbnRzLiBQ b3N0Z3JlcyBhbHdheXMgcmVzdGFydCByZXBsaWNhdGlvbiBmcm9tIHRoZSBtb3N0IHJlY2VudApz bmFwc2hvdCBXQUwgcmVjb3JkIHdoaWNoIGlzIG5vdCBzdWJvdmVyZmxvd2VkLCBiZWZvcmUgdGhl CmNvbmZpcm1lZF9mbHVzaF9sc24sIHdoaWNoIGNvdWxkIGJlIHNpZ25pZmljYW50bHkgYmVoaW5k IGlmIHRoZXJlIGFyZSBtYW55CnN1YnRyYW5zYWN0aW9ucyBydW5uaW5nLiBDbGllbnRzIGNhbiBy ZXF1ZXN0IChvbiBjb25uZWN0aW9uKSB0aGF0IGRlY29kaW5nCnN0YXJ0IGZyb20gYSBsYXRlciBM U04gKHNlZQpodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzLzEwL2xvZ2ljYWxkZWNvZGlu Zy1leHBsYW5hdGlvbi5odG1sI0xPR0lDQUxERUNPRElORy1SRVBMSUNBVElPTi1TTE9UUykuIg0K DQpPciBwZXJoYXBzIHRoaXMgaW5mb3JtYXRpb24gY291bGQgYmUgYWRkZWQgdW5kZXIgIjQ4LjIu Mi4gUmVwbGljYXRpb24KU2xvdHMiLCB3aXRoIGp1c3QgYSBsaW5rIGZyb20gdGhlIHJlc3RhcnRf bHNuIGVudHJ5Pw0KDQpUaGFua3MsIENocmlzLgo= --===============7633640925931430725==--