From dbyzaa@163.com Thu Aug  11 06:27:17 2016
Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M45730=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1bXjSX-0008Hg-6P
	for pgsql-admin@arkaria.postgresql.org; Thu, 11 Aug 2016 06:27:17 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M45730=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1bXjSW-0002hr-G2
	for pgsql-admin@arkaria.postgresql.org; Thu, 11 Aug 2016 06:27:16 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <dbyzaa@163.com>)
	id 1bXjQp-0000pa-20
	for pgsql-admin@postgresql.org; Thu, 11 Aug 2016 06:25:31 +0000
Received: from m12-11.163.com ([220.181.12.11])
	by magus.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <dbyzaa@163.com>)
	id 1bXjQY-0005Cu-T8
	for pgsql-admin@postgresql.org; Thu, 11 Aug 2016 06:25:27 +0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=163.com;
	s=s110527; h=Date:From:Subject:Mime-Version:Message-ID; bh=1YtGm
	OQYhZdaeLCwb7pvEXqG7gO5nRnoZiatALxcJcc=; b=M13O9nDs8wrpe4AfIacMg
	/EVJVMhpk+VL8JxEoYvglG1xa4CYVWwZ/6hl4B9PfoeaPxXqcw/nMYjEG0dlfEg/
	EWHjCDYp4G0VtOUieGwvmpNHum/vYroO2hSMp+q91Ns2hoVfgLSNDo7OD1nxBpf8
	3kAo2cGgToIMiVEEi6ocSc=
Received: from db (unknown [175.13.217.74])
	by smtp7 (Coremail) with SMTP id C8CowAAnkcw0GqxXxk+6CA--.61080S2;
	Thu, 11 Aug 2016 14:24:53 +0800 (CST)
Date: Thu, 11 Aug 2016 14:24:49 +0800
From: "dbyzaa@163.com" <dbyzaa@163.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: how can I  know WAL insert location When the primary crash
X-Priority: 3
X-GUID: 2BD8CD77-AE5A-44AD-97D3-945C00A86379
X-Has-Attach: no
X-Mailer: Foxmail 7, 2, 7, 174[cn]
Mime-Version: 1.0
Message-ID: <201608111424474182960@163.com>
Content-Type: multipart/alternative;
	boundary="----=_001_NextPart116252770076_=----"
X-CM-TRANSID: C8CowAAnkcw0GqxXxk+6CA--.61080S2
X-Coremail-Antispam: 1Uf129KBjDUn29KB7ZKAUJUUUUU529EdanIXcx71UUUUU7v73
	VFW2AGmfu7bjvjm3AaLaJ3UbIYCTnIWIevJa73UjIFyTuYvjxUOJ5FUUUUU
X-Originating-IP: [175.13.217.74]
X-CM-SenderInfo: xge16trd6rljoofrz/1tbiDhXCOFXlgXqroQAAsg
X-Pg-Spam-Score: 1.2 (+)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.

------=_001_NextPart116252770076_=----
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: base64

aGkNCiAgSW4gdGhlIHN0ZWFtaW5nIHJlcGxpY2F0aW9uICwgaG93IGNhbiBJICBrbm93IFdBTCBp
bnNlcnQgbG9jYXRpb24gV2hlbiB0aGUgcHJpbWFyeSBjcmFzaA0KDQoNCg0KZGJ5emFhQDE2My5j
b20NCg==

------=_001_NextPart116252770076_=----
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charse=
t=3Dus-ascii"><style>body { line-height: 1.5; }body { font-size: 10.5pt; f=
ont-family: 'Microsoft YaHei UI'; color: rgb(0, 0, 0); line-height: 1.5; }=
</style></head><body>=0A<div><span></span><span style=3D"font-family: &quo=
t;" microsoft=3D"" yahei=3D"" ui'";=3D"" font-size:=3D"" 14px;=3D"" color:=
=3D"" rgb(0,=3D"" 0,=3D"" 0);=3D"" background-color:=3D"" rgba(0,=3D"" fon=
t-weight:=3D"" normal;=3D"" font-style:=3D"" normal;text-decoration:=3D"" =
none;'=3D"">hi<br>&nbsp;&nbsp;In&nbsp;the&nbsp;steaming&nbsp;replication&n=
bsp;,&nbsp;how&nbsp;can&nbsp;I&nbsp;&nbsp;know&nbsp;WAL&nbsp;insert&nbsp;l=
ocation&nbsp;When&nbsp;the&nbsp;primary&nbsp;crash</span></div>=0A<div><br=
></div><hr style=3D"width: 210px; height: 1px;" color=3D"#b5c4df" size=3D"=
1" align=3D"left">=0A<div><span><div style=3D"MARGIN: 10px; FONT-FAMILY: v=
erdana; FONT-SIZE: 10pt"><div>dbyzaa@163.com</div></div></span></div>=0A</=
body></html>
------=_001_NextPart116252770076_=------






From dbyzaa@163.com Thu Aug  11 23:52:29 2016
Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M45735=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1bXzm0-0002a5-TO
	for pgsql-admin@arkaria.postgresql.org; Thu, 11 Aug 2016 23:52:29 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M45735=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1bXzm0-0004Wa-7H
	for pgsql-admin@arkaria.postgresql.org; Thu, 11 Aug 2016 23:52:28 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <dbyzaa@163.com>)
	id 1bXzkI-0002dr-JN
	for pgsql-admin@postgresql.org; Thu, 11 Aug 2016 23:50:43 +0000
Received: from m13-155.163.com ([220.181.13.155])
	by magus.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <dbyzaa@163.com>)
	id 1bXzk7-00072V-QD
	for pgsql-admin@postgresql.org; Thu, 11 Aug 2016 23:50:42 +0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=163.com;
	s=s110527; h=Date:From:Subject:MIME-Version:Message-ID; bh=+COT5
	bQQAA6RCILAh/W7i7KJ61JJS/cC7r/XxhEooA0=; b=D4udeMVy6lC3nrU0qge4P
	6GtxhqOLK/dqszX8DgCe8RSsS7ruvXJyjYGqo23FtzqH7KrgNxd0U9dK1Lf8t3ar
	P03pYItd4CYYNJHVbOFyVg4X9V58m9zeq3MNuargkcBvP+0NuqwERnPLBNHJYGwh
	kNRZw/b8jei0xnEdU0Zyqg=
Received: from dbyzaa$163.com ( [220.202.152.98] ) by ajax-webmail-wmsvr155
 (Coremail) ; Fri, 12 Aug 2016 07:50:18 +0800 (GMT+08:00)
X-Originating-IP: [220.202.152.98]
Date: Fri, 12 Aug 2016 07:50:18 +0800 (GMT+08:00)
From: =?GBK?B?tcux6w==?= <dbyzaa@163.com>
To: pgsql-admin  <pgsql-admin@postgresql.org>
Subject: Re: how can I know WAL insert location When the primary
 crash
X-Priority: 3
X-Mailer: Coremail Webmail Server Version SP_ntes V3.5 build
 20150911(74783.7961) Copyright (c) 2002-2016 www.mailtech.cn 163com
In-Reply-To: <201608111424474182960@163.com>
References: <201608111424474182960@163.com>
X-CM-CTRLDATA: zImQqWZvb3Rlcl9odG09MTgxNTo5
Content-Type: multipart/alternative;
	boundary="----=_Part_93484_346762074.1470959418190"
MIME-Version: 1.0
Message-ID: <1cea30d6.7b80.1567c037b4f.Coremail.dbyzaa@163.com>
X-CM-TRANSID: m8GowAAnX4k7D61XGsUKAA--.30058W
X-CM-SenderInfo: xge16trd6rljoofrz/xtbBUQXCOFaDrFiLwgABsH
X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU==
X-Pg-Spam-Score: -2.5 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

------=_Part_93484_346762074.1470959418190
Content-Type: text/plain; charset=GBK
Content-Transfer-Encoding: base64

cGdfeGxvZ2R1bXAgd2FsIC0tcm1ncj14bG9nCgoKt6LX1CDN+NLX08rP5LTzyqYKT24gMDgvMTEv
MjAxNiAxNDoyNCwgZGJ5emFhQDE2My5jb20gd3JvdGU6CmhpCiAgSW4gdGhlIHN0ZWFtaW5nIHJl
cGxpY2F0aW9uICwgaG93IGNhbiBJICBrbm93IFdBTCBpbnNlcnQgbG9jYXRpb24gV2hlbiB0aGUg
cHJpbWFyeSBjcmFzaAoKCmRieXphYUAxNjMuY29t
------=_Part_93484_346762074.1470959418190
Content-Type: text/html; charset=GBK
Content-Transfer-Encoding: base64

PGh0bWw+PGhlYWQ+PG1ldGEgaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0ZXh0
L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPjwvaGVhZD48Ym9keT4KICAgICAgICA8ZGl2IGlkPSJjb250
ZW50RGVzY3JpcHRpb24iIHN0eWxlPSJsaW5lLWhlaWdodDoxLjU7dGV4dC1hbGlnbjpqdXN0aWZ5
O3RleHQtanVzdGlmeTppbnRlci1pZGVvZ3JhcGgiPgogICAgICAgICAgICA8ZGl2PnBnX3hsb2dk
dW1wIHdhbCAtLXJtZ3I9eGxvZzwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXYgY2xhc3M9Ik5FVEVB
U0VNQUlMTUFTVEVSTE9DQUxTSUdOQVRVUkUiPjxzcGFuIHN0eWxlPSJjb2xvcjojODg4O2ZvbnQt
c2l6ZToxNXB4OyI+t6LX1CA8L3NwYW4+PGEgaHJlZj0iaHR0cDovL3UuMTYzLmNvbS9zaWduYXR1
cmUiIHN0eWxlPSJmb250LXNpemU6MTVweDtjb2xvcjojMmU5MGViOyIgdGFyZ2V0PSJfYmxhbmsi
Ps340tfTys/ktPPKpjwvYT48L2Rpdj4KICAgICAgICAgICAgPGRpdiBjbGFzcz0iYm9yZGVyRml4
V2lkdGggaU1haWxEb05vdFJlU2NhbGUiIHN0eWxlPSJiYWNrZ3JvdW5kLWNvbG9yOiNmMmYyZjI7
Y29sb3I6YmxhY2s7cGFkZGluZy10b3A6NnB4O3BhZGRpbmctYm90dG9tOjZweDtib3JkZXItcmFk
aXVzOjNweDstbW96LWJvcmRlci1yYWRpdXM6M3B4Oy13ZWJraXQtYm9yZGVyLXJhZGl1czozcHg7
bWFyZ2luLXRvcDo0NXB4O21hcmdpbi1ib3R0b206MjBweDsiPjxkaXYgc3R5bGU9ImZvbnQtc2l6
ZToxNHB4O2xpbmUtaGVpZ2h0OjEuNTt3b3JkLWJyZWFrOmJyZWFrLWFsbDttYXJnaW4tbGVmdDox
MHB4O21hcmdpbi1yaWdodDoxMHB4Ij5PbiAwOC8xMS8yMDE2IDE0OjI0LCA8YSBzdHlsZT0idGV4
dC1kZWNvcmF0aW9uOm5vbmU7Y29sb3I6IzJhOTdmZjsiIGhyZWY9Im1haWx0bzpkYnl6YWFAMTYz
LmNvbSI+ZGJ5emFhQDE2My5jb208L2E+IHdyb3RlOjwvZGl2PjwvZGl2PjxibG9ja3F1b3RlIGlk
PSJudGVzLWlvc21haWwtcXVvdGUiIHN0eWxlPSJtYXJnaW46MCI+PHN0eWxlPmJvZHkgeyBsaW5l
LWhlaWdodDogMS41OyB9Ym9keSB7IGZvbnQtc2l6ZTogMTAuNXB0OyBmb250LWZhbWlseTogJ01p
Y3Jvc29mdCBZYUhlaSBVSSc7IGNvbG9yOiByZ2IoMCwgMCwgMCk7IGxpbmUtaGVpZ2h0OiAxLjU7
IH08L3N0eWxlPgo8ZGl2PjxzcGFuPjwvc3Bhbj48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6ICZx
dW90OyIgbWljcm9zb2Z0PSIiIHlhaGVpPSIiIHVpPSIiIGZvbnQtc2l6ZTo9IiIgY29sb3I6PSIi
IHJnYj0iIiBiYWNrZ3JvdW5kLWNvbG9yOj0iIiByZ2JhPSIiIGZvbnQtd2VpZ2h0Oj0iIiBub3Jt
YWw9IiIgZm9udC1zdHlsZTo9IiIgbm9uZT0iIj5oaTxicj4mbmJzcDsmbmJzcDtJbiZuYnNwO3Ro
ZSZuYnNwO3N0ZWFtaW5nJm5ic3A7cmVwbGljYXRpb24mbmJzcDssJm5ic3A7aG93Jm5ic3A7Y2Fu
Jm5ic3A7SSZuYnNwOyZuYnNwO2tub3cmbmJzcDtXQUwmbmJzcDtpbnNlcnQmbmJzcDtsb2NhdGlv
biZuYnNwO1doZW4mbmJzcDt0aGUmbmJzcDtwcmltYXJ5Jm5ic3A7Y3Jhc2g8L3NwYW4+PC9kaXY+
CjxkaXY+PGJyPjwvZGl2PjxociBzdHlsZT0id2lkdGg6IDIxMHB4OyBoZWlnaHQ6IDFweDsiIGNv
bG9yPSIjYjVjNGRmIiBzaXplPSIxIiBhbGlnbj0ibGVmdCI+CjxkaXY+PHNwYW4+PGRpdiBzdHls
ZT0iTUFSR0lOOiAxMHB4OyBGT05ULUZBTUlMWTogdmVyZGFuYTsgRk9OVC1TSVpFOiAxMHB0Ij48
ZGl2PjxhIGhyZWY9Im1haWx0bzpkYnl6YWFAMTYzLmNvbSI+ZGJ5emFhQDE2My5jb208L2E+PC9k
aXY+PC9kaXY+PC9zcGFuPjwvZGl2Pgo8L2Jsb2NrcXVvdGU+CiAgICAgICAgPC9kaXY+CiAgICA8
YnI+PGJyPgo8L2JvZHk+PC9odG1sPg==
------=_Part_93484_346762074.1470959418190--